JavaScript - Javascript & Excel

Greetings!
Im new to this forum, looked around a bit and didnt find anything on this.
I im creating a web page, in witch i have to export data from a data base to excel files..
I already have a javascript using activeXobject, that exports the data to an excel table, what i also need to do is to create and pivot table in other excel sheet.
Ive been tottaly stuck on this for a couple of days, does anyone have an example of how to create an excel pivot table using JavaScript?
I would appreciate it so much =)

Thanks in advance!

Referring to following link, I would like to determine the link for "In-Depth.xls", based on following coding, I find related information for Excel.png, does anyone have any suggestions on how to determine the URL for Excel file?

Thanks in advance for any suggestions

http://fx.aastocks.com/en/forex/mark...0&indicator=47

<img src="../../images/common/Excel.png" id="cp_imgExcel" class="btn" onclick="window.location.href='dbindepth.aspx?country=66970&amp;startdate=2010/12/24&amp;enddate=2011/12/24&amp;indicator=47&amp;excel=1'"/>

Guys, this is a script which runs on a Mac not a browser.

I have created a script which transfers data from an Excel CSV file into an In-Design document and formats it, I am now just trying to take out some of the options for human error.

I need the script to Open the Excel file which has been selected by dialog box and then save it to the desktop as a csv file. I thought this bit would be simple, but I cannot get the file to even open.

Help please, Nick

Hi,

I have a code written in Javascript to export to Excel.
It is not working for my PC as open office is installed in it.
If I check with ms-office the code works, can anyone please suggest me what shld i do for it.
Below is the code in javascript.

function exportToExcel()
{
var oExcel = new ActiveXObject("Excel.Application");
var oBook = oExcel.Workbooks.Add;
var oSheet = oBook.Worksheets(1);
for (var y=0;y<detailsTable.rows.length;y++)
// detailsTable is the table where the content to be exported is
{
for (var x=0;x<detailsTable.rows(y).cells.length;x++)
{
oSheet.Cells(y+1,x+1) =detailsTable.rows(y).cells(x).innerText;
}
}

Please suggest me what code i should keep or what I should change.
-- Thanks in Advance..

For a project in my high school web design class, I need to integrate an Excel spreadsheet as data so to speak for a web page. I want to pull the prices from the sheet, and make them appear on the page. I'd like to pull it from the sheet so that the client can still adjust and edit the prices without having to reach the actual webpage. Conceptually, I thought this would be fairly straight forward, but in researching how to do this, I got very confused. I'm not even positive that I'm putting this in the right section.

So my main question is this:
Is there a way to integrate an Excel spreadsheet in such a way that it can provide data for certain fields of a webpage? If so, can someone please explain how?

Thanks,
A Confused High School Girl

in excel i want to replace the word bebo with a value in cell B1
this is the line
CREATE TABLE IF NOT EXISTS `bebo` ( `id` int(10) NOT NULL auto_increment,`beboid` varchar(255) default '0',`status` varchar(255) default 'No Comment Posted',PRIMARY KEY (`id`))

in column B i have a load of values
so i need an excel formula to replace bebo
so that it will take values from B1 to B26
any ideas please?

I know this is not the correct section to be posting in but couldnt find a relative section on this site..

Thanks for your help

Hi,

I need a javascript function to save a html table in my web page to excel work sheet on click of a button.Can somebody help me out with this.

I am creating a template generator page that generates a webpage based on what I fill in for certain elements like image name, img src, book title, book author, etc. and these values are sent to me in an excel document which right now I just open and copy and paste everything from the excel document into the form fields for each section.

So for example the client sends over a list of book titles they want featured on the page this week and they include author name, author link, book name, book url, img src, etc. and I just copy those new fields into my template and then click generate and the updated HTML code is there for me to copy.

This part works totally fine but in the interest of saving time copying upwards of 100 fields from an Excel file into my template, is there a way I can select the excel file (stored locally) on my page with a "browse" directory form and then have a button that runs SQL queries on my Excel document to pull these updated titles, images, etc into my form fields dynamically?

Do I need to utilize server technology for this or is there a simple script that when I click a button, will look at whatever excel file I have selected and say "grab this row at this column"?

What is the best way to do this?

Help! I'm relatively a noob when it comes to this stuff but I do know javavscript and SQL pretty well. I just can't figure out how to access my excel file to pull in the updated information.

The excel file's row and column structure never changes, just the content on each row and column.

Let me know if you can help. Thanks!!!!

Hi Chaps,

I have some Javascript code, that sucessfully exports Project data from an HTML table to an Excel SpreadSheet:
Code:

function ExportToExcel() {		
			var xlApp = new ActiveXObject("Excel.Application");
			// Silent-mode:
			xlApp.Visible = true;
			xlApp.DisplayAlerts = false;
			var xlBook = xlApp.Workbooks.Add();
			xlBook.worksheets("Sheet1").activate;
			var XlSheet = xlBook.activeSheet;
			XlSheet.Name="Project Details";
			
			// Store the sheet header names in an array
			var rows = tbldisplay.getElementsByTagName("tr");
			var columns = tbldisplay.getElementsByTagName("th");
			var data = tbldisplay.getElementsByTagName("td");
			
			//run over the dynamic result table and pull out the values and insert into corresponding Excel cells
			var d = 0;
			for (r=4;r<rows.length+3;r++) { // start at row 2 as we've added in headers - so also add in another row!
				for (c=1;c<columns.length+1;c++) {
					XlSheet.cells(r,c).value = data[d].innerText;
					d = d + 1;
				}
			}
			
			//autofit the columns
			XlSheet.columns.autofit;
			
			// Make visible:
			xlApp.visible = true;
			xlApp.DisplayAlerts = true;
			CollectGarbage();
			//xlApp.Quit();
}

As you can see, a new workbook is created and the data is exported to Excel ("Sheet1").
What I want to do is as soon as this export is complete, redirect to a seperate page, where the Jobs (linked to the Project) details are exported to Excel ("Sheet2"), without creating a new workbook.
Is this do-able?

Hello,

I am working on a project using (currently) HTML and javascript to allow the user to choose a vehicle from a drop down menu, then load a new page showing some information about this vehicle. The information is stored in two forms: SQL and Excel. I am looking for a way to use my HTML/javascript code to load the data from one of these files without having to code each option individually.

Important note: this will not use the internet at all: all of these files will be available locally. There is a lot of material on running queries to servers, but I didn't think that would really apply here.

Ideally the code would populate variables based on cells referenced in the Excel files (as I am familiar with Excel, but havne't used SQL at all).

Thank you,
klarosa

Edit: The users for this will all be using IE7

Hello everyone,
'recently converted an excel timesheet to a PDF form. Trying to get some help to convert two excel formulas (formulae?) into javascript.
First Excel formula is intended to return the value of "40" if the total is above 40, otherwise display actual value: =IF(L17>40, 40,L17)
Second excel formula is the "overtime" field, which displays the number of hrs above 40hrs, or displays "N/A" if below 40: =IF(L17>40, L17-40, "N/A")
I have essentially no experience in Javascript and I am trying to learn, but any help to get me over this hump will be appreciated.
Regards
tim

I am working on some sort of a program that will load data from a notepad or Excel file and load it into a ComboBox. The notepad file would have names and phone numbers in it. The ComboBox would only show their names in alphabetical order. There would also be a button that when you click it, it would open up Outlook (if you are signed into Outlook) and auto-fill the form with their phone number @ vtext.net (for texting verizon cell phones). The reason behind this is so the notepad or Excel file can be edited to add more users as the company expands.

I'm on a time crunch and haven't really been able to figure out how to do the data on load.

If anyone could help and explain their code a little bit I would be very grateful. I haven't touched JavaScript in around 5 years so I'm very rusty. Thanks.

hi guys,

I have built an rss ripper, the point is to bypass technology restrictions when exporting from sharepoint to excel 2003.

My problem i'm using the code below to output data in a nice html tabular format, however when trying to import into excel via web query i get no data returned, i think this is as it isn't real html, i've made a few alterations and am now getting account pulled back - how do i get it to pull all the data ?

code is as follows, also i've put a link at the bottom to w3 so you can get a good idea of the issue:

<%@ Language=VBScript %>
<html>
<head>
<script type="text/javascript" src="loadxmldoc.js"></script>
</head>

<body>
<script type="text/javascript">

function loadXMLDoc()
{
if (window.XMLHttpRequest)
{
xhttp=new XMLHttpRequest();
}
else
{
xhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xhttp.open("GET","my file path",false);
xhttp.send();
return xhttp.responseXML;
}

xmlDoc=loadXMLDoc("");
uppernum=(xmlDoc.getElementsByTagName( "title" ).length );
accstartnum=2
detstartnum=1
qlow = 0
qhi = 12
//document.write("<table border=1")
</script><table border = 1><tr><script>
z=xmlDoc.getElementsByTagName("description")[detstartnum]
</script><td>Account</td><script>
y=z.childNodes[0];
data_dump = (y.nodeValue);
data_dump = data_dump.replace(/<div><b>/g,"");
data_dump = data_dump.replace(/div>/g,"");
data_dump = data_dump.replace(/b>/g,"");
data_dump = data_dump.replace(/</g,"");
data_dump = data_dump.replace(/\n/g,"");
data_dump = data_dump.replace(/\//g,"");
data_array = data_dump.split(":");
array_pos = 0
while (array_pos < data_array.length)
{
if (array_pos%2)
{
document.write ("<td>" + data_array[array_pos] + "</td>");
array_pos+=1;
}
else
{
array_pos+=1;
}
}
document.write("</tr>")
while (accstartnum < uppernum)
{
document.write("<tr>")
x=xmlDoc.getElementsByTagName("title")[accstartnum]
y=x.childNodes[0];
acc = (y.nodeValue);
z=xmlDoc.getElementsByTagName("description")[detstartnum]
y=z.childNodes[0];
data_dump = (y.nodeValue);
data_dump = data_dump.replace(/<div><b>/g,"");
data_dump = data_dump.replace(/div>/g,"");
data_dump = data_dump.replace(/b>/g,"");
data_dump = data_dump.replace(/</g,"");
data_dump = data_dump.replace(/\n/g,"");
data_dump = data_dump.replace(/\//g,"");
data_array = data_dump.split(":");
array_pos = 1
document.write("<td>" + acc + "</td>")
while (array_pos < data_array.length)
{
if (array_pos%2)
{
array_pos+=1;
}
else
{
document.write ("<td>" + data_array[array_pos] + "</td>")
array_pos+=1;
}
}
accstartnum+=1;
detstartnum+=1;
document.write("</tr>")
}
</script></table><script>


//url = document.location.href;
//urll = url.split("?");
//if (urll.length == 0)
// {
// document.self.location.replace("http://midevsso.gcf-uk.gcf.capital.ge.com/Development/rssreader.asp?reload=1");
// }

</script>
</body>
</html>





if you have excel 2003 you can get an idea of the issue by trying to import the table he
http://www.w3schools.com/XML/tryit.a..._display_table

Hi ,,


im trying to access cells in the excel , but when iam using variabel inActiveSheet.Cells(1,k) im getting error "Expected :". Could you please help me. Big Thanks in Advance

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1250" />
<script>
function CreateExcel()
{
var ExcelSheet;
var i=0;
var 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:\\Book1.xls");
ExcelApp.Visible = false;
var i=1;
for(i=0;i<10;i++)
{
var k=i;
document.write(ExcelApp.Workbooks.Open("C:\\wiki estimation.xls").ActiveSheet.Cells(1,k).Value);
}
ExcelApp.Quit();
//ExcelSheet.Application.Quit();
}
</script>
<input type=button name=mybutton value=ExcelSheet onclick="CreateExcel()">
</head>

<body>
</body>
</html>