Jump to content

File Properties Access with ASP


tyneet
 Share

Recommended Posts

You need to save the file as a CSV file and then you can read it and split up the lines to get your data.
My excel file has 7 sheets in it and can not save this file as a CSV file unless I split each sheet into a seperate file. This will not work for us. There are multiple sheet formulas that I can not split up. Plus we use a template file. So there will be multiple files that I want to read the property information. So I need to read the .xls properties files.Any other options?Thanks justsomeguy for the help!!!!!!!! Really appreciate it.Tony
Link to comment
Share on other sites

you can probably do this with an instance of the Excel.Application. It would mean that you need Excel installed on your server as well as the appropriate permissions set for IIS to access Excel. You will then need to study up on the methods and objects that Excel exposes through automation.To get you started:<%@ language="vbscript" %><%Dim oExcelDim oWorkbookDim oWorksheetSet oExcel = Server.CreateObject("Excel.Application")Set oWorkbook = oExcel.Workbooks.Open("workbook.xls")Set oWorksheet = oWorkbook.Sheets("Sheet1")Response.Write(oWorksheet.Name)%>

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...