We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

regarding opening of csv files in excel

Thread ID:

Created:

Updated:

Platform:

Replies:

64427 Jul 20,2007 05:21 AM UTC Jul 26,2007 01:28 PM UTC ASP.NET Web Forms (Classic) 3
loading
Tags: XlsIO
sunil kumar
Asked On July 20, 2007 05:21 AM UTC

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 [Syncfusion]
Replied On July 20, 2007 09:18 AM UTC

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
Replied On July 25, 2007 07:14 AM UTC

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 [Syncfusion]
Replied On July 26, 2007 01:28 PM UTC

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





CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;