regarding opening of csv files in excel

[sunil kumar]

Hi,

I am trying to open a existing csv files programmatically with xlsio.
I am using the following code:
objExcel = New ExcelEngine
iExcelApp = objExcel.Excel
objWkBook = objExcel.Excel.Workbooks.Open(strFilename, ExcelOpenType.csv)
objSheet = objWkBook.Worksheets(0)
But I am not able to do so.
Can anyone tell me if there is any other function used for that.

Thanks in advance
sunny

[Melba Winshia]

Hi Sunny,

Thank you for your interest in Essential XlsIO.

You can refer the below Kb article to open and save CSV files.

http://www.syncfusion.com/support/kb/xlsio/Default.aspx?ToDo=view&questId=65

Please let me know if you have any other questions.

Thanks,
Melba

[sunil kumar]

Hi,

I am using the given code in my web application. But when the number of rows are more(more than 30000) but less than 65000(which is the row limit of excel)the application hangs.
For less number of data it is working fine.

Do u have any idea why it is happening so/

Thanks,
sunny

>Hi Sunny,

Thank you for your interest in Essential XlsIO.

You can refer the below Kb article to open and save CSV files.

http://www.syncfusion.com/support/kb/xlsio/Default.aspx?ToDo=view&questId=65

Please let me know if you have any other questions.

Thanks,
Melba

[Melba Winshia]

Hi Sunny,

Thank you for posting your query to us.

I am afraid that I was not able to reproduce the issue. Please refer to the following steps that I tried to reproduce it.

1. Created a file which has data with 65000 rows
2. Opened that file using XlsIO.
3. The file opens without any issues.

Also I have created a simple sample to test this issue and it is available in the following link.

http://websamples.syncfusion.com/samples/XlsIO.Windows/F64427/main.htm

Please have a look at the above sample and if still the issue exists, could you please try reproducing it in the above sample or send us the reproducing steps and also could you please provide us the specific file you used in this case so that we could sort out the cause of the issue and provide you a solution?

Thank you for using Syncfusion products.

Thanks,
Melba