-
June 15th, 2007, 11:22 PM
#1
Export to CSV or Excel Multiple Sheets
Hello Code Gurus
This is the Code which i wrote to export records to CSV file Format, Which then eventually opens in Excel.
[CODE]
If F.FileExists("C:\file1.csv") = True Then
F.DeleteFile "C:\file1.csv", True
End If
Set F1 = F.OpenTextFile("C:\file1.csv", ForWriting, True, TristateFalse)
F1.WriteLine "Delivered Bills "
F1.WriteLine "Date,Bill No,Delivered To,Relation,Contact No,Delivery Time"
F1.WriteLine
F1.WriteLine RSTemp.GetString(adClipString, , ",")
F1.Close
Set F1 = Nothing
MsgBox "File Exported to C:\file1.csv", vbInformation, "Info"
[CODE]
But when I open it with Excel, It opens in a single Sheet and has limits 65536 rows.
My Question is how to go about exporting the CSV file to open in Multiple Sheets .
I want to do it without using Excel Object, (beacuse if Ecel is not found in the Client Machine !)
Any Help , suggestions !!!!! Please
-
June 19th, 2007, 05:01 AM
#2
Please
Hey Guys Please Somebody Help me....
-
September 15th, 2009, 12:47 AM
#3
-
June 19th, 2007, 05:49 AM
#4
Re: Export to CSV or Excel Multiple Sheets
Originally Posted by RajWolf
I want to do it without using Excel Object, (beacuse if Ecel is not found in the Client Machine !)
I think you have to use excel object. If excel is not there on client machine then how will you open your .csv file on multiple sheets in excel??
Tricky!!!
-
June 19th, 2007, 07:56 AM
#5
Re: Export to CSV or Excel Multiple Sheets
Oh No No.
Actually I am Exporting in the .CSV File format so that it can be opened in EXCEL Or OPEN OFFICE Spread Sheet.
So I'll Reframe my Question.
How to Export .CSV file in such a format that it must open in Multiple Sheets of EXCEL or OPEN OFFICE.
-
June 21st, 2007, 01:42 AM
#6
Re: Export to CSV or Excel Multiple Sheets
Please AnyBody
Mr. WoF , JonnyPoet
Please
-
June 26th, 2007, 09:19 AM
#7
Re: Export to CSV or Excel Multiple Sheets
What Should I to with this thread ?
-
June 26th, 2007, 09:46 AM
#8
Re: Export to CSV or Excel Multiple Sheets
Sorry, RajWolf, even if you address me directly, I have to admit that I'm not an expert with Excel sheets.
As I look at your code I don't even understand how it could export anything from an excel-file.
I'd try to use Excel to export a .csv file first. Multi sheet of course. Then I'd examine the file. The .csv format is readable ASCII, so any information for multiple sheets will be seen. Maybe you have to add lines to create such info in your export function...
Maybe it becomes clearer if you could provide a sample .csv file you have created with Excel and which you have tried to reimport successfully.
-
June 26th, 2007, 10:00 AM
#9
Re: Export to CSV or Excel Multiple Sheets
Okay here's the skinny on the subject.....
EXCEL : has limits... Noticably - 255 columbs and 65535 rows... (per sheet) more specifically in Hex it has HFF col & HFFFF rows...
You can not exceed this at all, and excel simly dumps the extra with a warning...
CSV : Is a raw data format.. It does NOT have ANY commands that can be placed in it...
With this in mind, All that you can do is to check your CSV output and trim it to 65534 rows of data and then write the rest into a second file (again checking for file length)...
There after you can write a script in excell to import the files into seperate sheets of a single workbook...
I've done plenty of work with CSV and Excel and can assit you with this...
Gremmy...
Articles VB6 : Break the 2G limit - Animation 1, 2 VB.NET : 2005/8 : Moving Images , Animation 1 , 2 , 3 , User Controls
WPF Articles : 3D Animation 1 , 2 , 3
Code snips: VB6 Hex Edit, IP Chat, Copy Prot., Crop, Zoom : .NET IP Chat (V4), Adv. ContextMenus, click Hotspot, Scroll Controls
Find me in ASP.NET., VB6., VB.NET , Writing Articles, My Genealogy, Forum
All VS.NET: posts refer to VS.NET 2008 (Pro) unless otherwise stated.
-
June 26th, 2007, 11:22 AM
#10
Re: Export to CSV or Excel Multiple Sheets
Why are you trying to save it as a csv file? That will only open in Excel, and as Gremmy said, has limits.
Save a txt file (or .wri, to open it in Wordpad). Then you could load it into Word, or import it into Access, which would be your best bet.
-
June 30th, 2007, 08:05 AM
#11
Re: Export to CSV or Excel Multiple Sheets
You can export directly to excel sheet in an xls file by using the access oledb driver. It supports all kinds of file formats besides just the access mdb type. Check it out. You should be able to create a multiple sheet xls file that can be opened by excel and by open office.
-
June 30th, 2007, 12:27 PM
#12
Re: Export to CSV or Excel Multiple Sheets
The link I posted does write out to multiple sheets.
-
September 15th, 2009, 09:08 AM
#13
Re: Export to CSV or Excel Multiple Sheets
You might have not noticed that this thread is already 2 years old.
I don't even know if theguy you are addressing is still around.
For a new problem please open a new thread and describe what you need.
-
March 24th, 2011, 12:42 AM
#14
Re: Export to CSV or Excel Multiple Sheets
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|