Bharath,
In your Sample.xls sheet, you have 4 rows of actual data and about 150 rows of Pick List.
For my application, I only want to import those 4 rows of actual data into a datagrid.
Currently, when I use your example, all 150 rows are imported into my datagrid. I only want the 4 rows to be imported.
Is this a bug? ( I am using Web form)
>Bharath,
>
>:( Mine is a web form. And I am using your line of code in my web form.. and still I am getting all the rows with the Pick List regardless if any rows are populated.
>
>Is there a bug in the Web form vs Win Form?
>
>>Hi,
>>
>>I am afraid.I was unable to reproduce the problem. Here is the code that I used for testing,
>>
>>
>>sheet.ExportDataTable(10 (int firstrow),1 (int firstcolumn), (100 for eg.) sheet.UsedRange.End.Row (int maxrows), 1 (int
>>
>>maxcolumns),ExcelExportDataTableOptions.None);
>>
>>
>>it exports 100 rows and 1 column(i.e from 10 to 109).
>>
>>and here is the sample that I used for testing:
>>
>>
ExtractData.zip
>>
>>
>>Please take a look at the attached sample and tell me if you still have the problem if so could you please modify the sample to
>>
>>reprodue the issus and send me, so that I can investigate further on this issue.
>>
>>Thanks,
>>Bharath.