Fill data in Excel table -- dotnet odbc.net

dotnet odbc.net : Fill data in Excel table

Jan
11/12/2005 12:00:00 AM

Hi,

If you can't use automation and Jet OLE DB doesn't have the power you need,
only other solution is to use some third-party control. If the amount of
data you are exporting is not large (less than 5 sheets and 150 rows per
sheet), you have ExcelLite Free component you can freely use in commercial
apps (http://www.gemboxsoftware.com/ExcelLiteFree.htm). If your worksheet
grows in size, you can easily update to ExcelLite Professional.

Jan
GemBox Software
www.gemboxsoftware.com

[quoted text, click to view]

Nikolay Petrov
11/12/2005 12:48:02 AM

I need to fill data in Excel table. I have an Excel workbook, where
some values should be filled in specified cells. I need to do this
without COM interop, because i don't have Excel installed. I red that
ADO.NET does not support 'Insert' and 'Update' statments against excel
files. Any ideas how to fill the table?

TIA

Nikolay Petrov
11/12/2005 6:20:47 AM

I need to fill 10 to 20 cell only. at specific locations in excel
template. that's all

Nikolay Petrov
11/12/2005 6:23:33 AM

Ken. It was my mistake. Before some time, i've tried to delete records
in excel file, and I red this KB article. This time, i forgot that only
deletion is not possible. Sorry, my memory is not so good these days.
Thanks however.

Ken Tucker [MVP]
11/12/2005 7:05:13 AM

Hi,

http://support.microsoft.com/default.aspx?scid=kb;en-us;316934

Ken
---------------
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about dotnet odbc.net

home · blog · groups

Questions? Comments? Contact the dn