Fill data in Excel table

  • Thread starter Thread starter Nikolay Petrov
  • Start date Start date
N

Nikolay Petrov

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
 
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
 
I need to fill 10 to 20 cell only. at specific locations in excel
template. that's all
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Series fill only copying and fill series greyed out 1
Displaying zeros in cells 2
Excel Bilinear interpolation 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Second fill in Ado.recordset does not fill table 4
Retrieve data from Access database and fill data in form 0
Ole DB Jet 4.0 Provider corrupts recipient Excel database predicta 3
Excel Making a cell Mandatory 9

Back
Top