writing xls files

[p4p800]

i want this to have two columns in excel can i do that

 

 

Dim writer As New System.IO.StreamWriter("test.xls")
       writer.Write(ComboBox1.Items(0))
       writer.Write(ComboBox1.Items(1))
       writer.WriteLine(a)
       writer.WriteLine(b)
       writer.Flush()
       writer.Close()

[mutant]

Im sure Excel format is much more complicated than that so I think that won't work. Edited March 3, 2004 by mutant

[Iceplug]

The 'easiest' way would probably be to add the Reference to the MS Excel ##.# library, create your workbooks and worksheets through code, or somehow, and then use Excel library methods to save an excel .Xls spreadsheet file. :)

[TechnoTone]

If you don't care about formatting, you can write a file in CSV (Comma Separated Values) format. This involves placing a comma between each column and surrounding each column with "". End each row with a new line.

 

CSV files will open in Excel - Excel is the default program associated with them.

 

Dim writer As New System.IO.StreamWriter("test.xls")
writer.Write("""" & ComboBox1.Items(0) & """,")
writer.Write("""" & ComboBox1.Items(1) & """")
writer.WriteLine()
writer.Close()

[filip]

Hi,

 

easiest way to work with Excel in .NET is by using 3rd party component. You can try GemBox.Spreadsheet - Excel component for .NET that is free to use if you have files smaller then 150 rows.

 

Here you can see a list of reasons why GemBox.Spreadsheet is better to use when working with Excel then Excel Automation.

 

Filip

GemBox.Spreadsheet - easiest way to read and write Excel files in .NET

[gbucsariu]

Hi! Take a look at EasyXLS library. It's very easy to use and there is also a User Guide available on their website.

[Agent707]

Wow, this forum doesn't get much action. 3 posts this year... including an 8 year old thread necro.