Dataset export.

[LinoX]

Hi. I found some problems I already fixed (maybe you will want to
include it in your code trunk)

here is the code:
DataSetHelper.cs line 95 should be changed from
worksheet.Cells[j + 1, i] = new Cell(dt.Rows[j][i].ToString());
to
worksheet.Cells[j + 1, i] = new Cell(dt.Rows[j][i]);

this will export the file with a more proper format.


WorkSheetEncoder.cs line 113 should be changed from
if (value is int || value is short || value is uint)
to
if (value is int || value is short || value is uint || value is byte)

this will allow byte values to be exported as a number without giving
an exception.

Bye,
LinoX

[Stephen Bedford]

Thanks for the update.

How can I download the latest source for ExcelLibrary?

The zip file I downloaded from
http://code.google.com/p/excellibrary/downloads/list does not have some of
the office routines I can see that others are using.

I need to read a spread sheet like this sample code.

using ExcelLibrary.Office.Excel;

Workbook workbook = Workbook.Open(filePath);

The ExcelLibrary.dll from the source code I have downloaded does not have
allow this code.

Kind regards
Stephen

Bye,
LinoX

--
You received this message because you are subscribed to the Google Groups
"excellibrary" group.
To post to this group, send email to excell...@googlegroups.com.
To unsubscribe from this group, send email to
excellibrary...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/excellibrary?hl=en.

[Stephen Bedford]

Hello Again

Disregard my previous email. I have managed to download the latest source
using SVN.

Have also found that ExcelLibrary.Office.Excel is now
ExcelLibrary.SpeeadSheet and Workbook.Open is now Workbook.Load.

Kind regards
Stephen

-----Original Message-----
From: excell...@googlegroups.com [mailto:excell...@googlegroups.com]
On Behalf Of LinoX
Sent: Thursday, 24 March 2011 1:23 AM
To: excellibrary
Subject: Dataset export.

Bye,
LinoX

--