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 wont work.

 

[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 dont 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