/    Sign up×
Community /Pin to ProfileBookmark

how to upload data from Excel

Copy linkTweet thisAlerts:
Nov 26.2007

Hi All,
While Clicking on button it should populate the datas in Excel into table .. so I need help of you ppl how to implement this thing using Java Script code..

Thanks in advance!

Reena…….

to post a comment
JavaScript

2 Comments(s) ↴

Copy linkTweet thisAlerts:
@ReenaauthorNov 26.2007 — <SCRIPT Language="Javascript">

var excel = new ActiveXObject("Excel.Application");

var excel_file = excel.Workbooks.Open("C:ESE.xls");

var excel_sheet = excel.Worksheets("Sheet1");

var data = excel_sheet.Cells(1,1).Value;

</SCRIPT>

I have used above code..But while clicking on button, it has displayed only first cell value of excel into textarea or tbl..I need to populate all the datas in excel into table..

help me out...
Copy linkTweet thisAlerts:
@ReenaauthorNov 26.2007 — I need to populate datas from excel into table using java script..

while clicking on buuton I have called fun fetch(), but it has displayed only value of cell(1,1) into table..

can any one guide me to impl this...

<SCRIPT Language="Javascript">

function fetch(){

var excel = new ActiveXObject("Excel.Application");

var excel_file = excel.Workbooks.Open("C:ESE.xls");

var excel_sheet = excel.Worksheets("Sheet1");

var data = excel_sheet.Cells(1,1).Value;

}

</SCRIPT>
×

Success!

Help @Reena spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 6.18,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @nearjob,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,
)...