Process Excel File

[Guest]

Good Day,

I have a web application created using ASP.NET (with VB.NET). The
application allow user to browse Excel raw data file then the program will
grab data from the file to perform further data processing.

The question is I'm doing this by creating an Excel application everytime to
do the processing which in other words ActiveX object is being created. New
release of IE is blocking the ActiveX object which causes my application fail
to perform Excel file processing.

Is there a way to perform the things the application need to do without
creating the ActiveX object? Sound like OWC only manage to allow data
populating to Excel file and not able to read data from Excel file.

Appreciate your help. Thanks!

 

[zacks]

Good Day,

I have a web application created using ASP.NET (with VB.NET). The
application allow user to browse Excel raw data file then the program will
grab data from the file to perform further data processing.

The question is I'm doing this by creating an Excel application everytime to
do the processing which in other words ActiveX object is being created. New
release of IE is blocking the ActiveX object which causes my application fail
to perform Excel file processing.

Is there a way to perform the things the application need to do without
creating the ActiveX object? Sound like OWC only manage to allow data
populating to Excel file and not able to read data from Excel file.

Appreciate your help. Thanks!

I have an app I wrote in VB.NET (VS2005) that reads the contents of
Excel spreadsheets using the Microsoft Excel Driver. It is an ODBC
driver, so once you open a connection to the worksheet in your
spreadsheet, you can access the data with SQL Select statements.
Connection string I use is:

Driver={Microsoft Excel Driver (*.xls)};Dbq=<full path to excel XLS
file>;DriverID=790

Select statement looks like:

SELECT TOP 1 * FROM [WORKSHEETNAME$]

 

[Guest]

Hi Zacks,

Appreciate and thanks for your reply

The Excel raw data file incorporates some specific cells which are being
assigned with a name (but the position of the cell is not fixed from one file
to another). I need to grab the value from those specific cells, is there any
way to do this?

I also need to loop through the Excel worksheet to grab certain data if met
with certain keyword contained inside the value. Any better way to do this
looping?

Thank you very much!

Good Day,

I have a web application created using ASP.NET (with VB.NET). The
application allow user to browse Excel raw data file then the program will
grab data from the file to perform further data processing.

The question is I'm doing this by creating an Excel application everytime to
do the processing which in other words ActiveX object is being created. New
release of IE is blocking the ActiveX object which causes my application fail
to perform Excel file processing.

Is there a way to perform the things the application need to do without
creating the ActiveX object? Sound like OWC only manage to allow data
populating to Excel file and not able to read data from Excel file.

Appreciate your help. Thanks!

I have an app I wrote in VB.NET (VS2005) that reads the contents of
Excel spreadsheets using the Microsoft Excel Driver. It is an ODBC
driver, so once you open a connection to the worksheet in your
spreadsheet, you can access the data with SQL Select statements.
Connection string I use is:

Driver={Microsoft Excel Driver (*.xls)};Dbq=<full path to excel XLS
file>;DriverID=790

Select statement looks like:

SELECT TOP 1 * FROM [WORKSHEETNAME$]