Reading Excel Sheet on client side

vinod_yadav1919 · November 8th, 2004, 07:45 AM

Hii Everybody,
1)I want to read data from the client machine,is it possible using javascript.
2)I want to write the contents to the same Excel file but on the second row.
e.g Below code is used for writing first two coloumns of Excel Sheet.

<script>
function CreateExcel()
{
var ExcelSheet;
ExcelApp = new ActiveXObject("Excel.Application");
ExcelSheet = new ActiveXObject("Excel.Sheet");
ExcelSheet.Application.Visible = true;
ExcelSheet.ActiveSheet.Cells(1,1).Value = "C11";
ExcelSheet.ActiveSheet.Cells(1,2).Value = "C12";
ExcelSheet.SaveAs("C:\\Test\\default.xls");
ExcelSheet.Application.Quit();
}
</script>
<input type=button name=mybutton value=ExcelSheet onclick="CreateExcel()">

My question is that is it possible to increment the row in the second time,and persist the values of the first row that i was entered previously.
Since whenever i click the button same file is overwrites again,How i can open the same file 2nd time and write the data from the next row on the client Side.
Since on the client side i can define a global variable that maintain the row number,but how i will append the next value to the same ExcelSheet
Please give me some clue to solve it.

vinod

vinod_yadav1919 · November 26th, 2004, 02:10 PM

Hii All,
I got the Answer !!!
Offcourse ,we can read/write/append the files on the Client Side.
Cheers :)

Cheers :)

vinod

pallone · November 30th, 2004, 09:51 AM

Hi vinod,

could you please post the complete code so that we could have a look??

Cheers,

Claudio

bhaveshmaru · January 9th, 2006, 03:36 AM

Hi vinod/All,
Can u Give the Details of how we can replace the modifying Excel sheet at the client Pc.
could you please post the complete code so that we could have a look??

Thanks in advance.

kamrag · September 27th, 2006, 05:12 AM

could you please give me the details how you did this

Thanks in advance
Rookie

Quote:

quote:Originally posted by vinod_yadav1919
Hii Everybody,
1)I want to read data from the client machine,is it possible using javascript.
2)I want to write the contents to the same Excel file but on the second row.
e.g Below code is used for writing first two coloumns of Excel Sheet.

<script>
function CreateExcel()
{
var ExcelSheet;
ExcelApp = new ActiveXObject("Excel.Application");
ExcelSheet = new ActiveXObject("Excel.Sheet");
ExcelSheet.Application.Visible = true;
ExcelSheet.ActiveSheet.Cells(1,1).Value = "C11";
ExcelSheet.ActiveSheet.Cells(1,2).Value = "C12";
ExcelSheet.SaveAs("C:\\Test\\default.xls");
ExcelSheet.Application.Quit();
}
</script>
<input type=button name=mybutton value=ExcelSheet onclick="CreateExcel()">

My question is that is it possible to increment the row in the second time,and persist the values of the first row that i was entered previously.
Since whenever i click the button same file is overwrites again,How i can open the same file 2nd time and write the data from the next row on the client Side.
Since on the client side i can define a global variable that maintain the row number,but how i will append the next value to the same ExcelSheet
Please give me some clue to solve it.

vinod

starboy · December 8th, 2009, 09:36 AM

hi, mr vinod
thanks.

could you detail the reading excel data with javascript?
or could you show me the example code?

thank you and regards.
starboy

joefawcett · December 8th, 2009, 10:28 AM

Very few are going to want to start up an old thread like this. Start a new one with a decsription of your problem. What environment, which version of Excel sheet etc?

starboy · December 8th, 2009, 09:13 PM

hi, vinod

well noted your message.

my problem is that read the msexcel2003 data and display the contents in the table of same html page.
i can accept the excel filename using input file type tag of html, but i cant implement the reading the excel data with the filename in javascript.

of course, i can read and display the excel data using jsp code.
but i cant get the excel filename from javascript variable.
so i decided the reading excel data in javascript.
please kindly detail your opinion.

thanks.