Formatting problems

[S. Long]

I am having problems with an existing report written in vb.net / asp.net 2003 that we are trying to introduce ExcelRW into to utilize it''s Bolding capabilities. The Bolding works fine, however we are having great difficulties with writing subheaders onto the Excel spreadsheet. Is there an easy way to do this any help is greatly appreciated. The problem seems to be with the need to make the rom and column loop dynamic instaed of based on a constant i.e. when the form is submitted the query returns a different dataset every time and the row and column varibales need to be loaded dynamically instead of with constants as is seen in the examples we have. When we try to do this ExcelRW fails to load each record in a given loop sequentially i.e. FOR I TO DATATABLEROWCOUNT (say DATATABLEROWCOUNT equals ''30'' ExcelRW will only write the 30th record 30 times instead of records 1 thru 30.

[Administrator]

Hi S.Long,

Could you please provide a sample demonstrating this issue in a winforms/webforms sample. I see no reason why there should be any problem in working with dynamic data. If its not possible to provide a sample, please provide the complete code snippet involving excelrw.

Thanks,

Stephen.

>I am having problems with an existing report written in vb.net / asp.net 2003 that we are trying to introduce ExcelRW into to utilize it''s Bolding capabilities. The Bolding works fine, however we are having great difficulties with writing subheaders onto the Excel spreadsheet. Is there an easy way to do this any help is greatly appreciated. The problem seems to be with the need to make the rom and column loop dynamic instaed of based on a constant i.e. when the form is submitted the query returns a different dataset every time and the row and column varibales need to be loaded dynamically instead of with constants as is seen in the examples we have. When we try to do this ExcelRW fails to load each record in a given loop sequentially i.e. FOR I TO DATATABLEROWCOUNT (say DATATABLEROWCOUNT equals ''30'' ExcelRW will only write the 30th record 30 times instead of records 1 thru 30.

[S. Long]

What you have asked for has been linked to Update Incident: 17272 and emailed to [e-mail] at Fri 3/11/2005 12:15 PM