Reply to topic  [ 2 posts ] 
Specify starting cell when writing to XL from DataSet 
Author Message

Joined: Fri Sep 28, 2007 12:00 pm
Posts: 1
Location: Dallas, Tx
Reply with quote
Post Specify starting cell when writing to XL from DataSet
Hello there;

Using the easy_WriteXLSFile_FromDataSet() method, I can read data from a DB and send it to an XL spreadsheet. However, the method always uses cell A1 as the starting point to load the data.

Is there anyway(maybe a different method) to set a specific cell, other than A1, as the starting point when loading/writing data ?

I may just be missing a couple of obvious ways to achieve this.. I just started reviewing the app yesterday.. so my apologies if the answer is too obvious.

Thanks in advance for your help.

Juan G. Rolón

Fri Sep 28, 2007 12:20 pm

Joined: Fri Feb 03, 2006 12:23 pm
Posts: 159
Location: Brasov, Romania
Reply with quote
You can use one of the easy_WriteXLSFile_FromDataSet methods that has a start cell, like:
easy_WriteXLSFile_FromDataSet(System.String sPath, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)

Mon Oct 01, 2007 4:32 am
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 2 posts ] 

Who is online

Users browsing this forum: No registered users and 1 guest

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.