how to get names of worksheets in excel file?
i am new in JavaScript programming
i want java script to find the names of worksheets in excel file
scenario
1) file upload control in a HTML
2) when user selects the file
3) HTML text box should display comma separated names of worksheet
||_|_||_||_||_|
||_|_||_||_||_|
||_|_||_||_||__|
__GERMANY__/__UK__/__IRELAND__/
Please also suggest me event of file upload control on which call to java script function is to be made
thanks in advance
You haven't posted any code here, so I will assume you haven't even started this process and you need to know where to go. Basically, what you want to do is possible but it will be a lot of work and it will only work on Internet Explorer (because you use ActiveX).
To start with, here is a forum post that gives some example code of opening an Excel file and working with it. This will be a good place to start:
Next, you will need to look at the Excel Object Model reference guide for any features or functionality you may want:
http://msdn.microsoft.com/en-us/library/bb149081.aspx
Specifically, you want to look at the Sheets list:
http://msdn.microsoft.com/en-us/library/bb178404(v=office.12).aspx
Basically, you should be able to open the Excel file and reference the Sheets() list to get the names of all of the sheets in the file.