|
JavaScript - Opening Excel File
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 Similar TutorialsReferring 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&startdate=2010/12/24&enddate=2011/12/24&indicator=47&excel=1'"/> Hello, I am in the midst of designing an HTA application, such that I would be able to open a file via notepad in Javascript using the Shell.Application object. I have the following code, however, It does not work and can't seem to figure the rest out. Code: function test101() {
var oShell = new ActiveXObject("Shell.Application")
var commandtoRun = 'C:\\WINDOWS\\system32\\notepad.exe "F:\\WEB\\saved items\\A-2010-00455.txt"'
oShell.ShellExecute(commandtoRun,"","","open","1");
}
Any help with this is greatly appreciated. Thanks in advance. Cheers, Jay 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, i want to open a file in a text area, such that the user can either browse for a file and when selected it will open in a text box on the page, or the user can select a file from a list of active links on the page and this will open in the text area. I am new to java and dont know where to start on this, i have been browsing resources on the internet but have not found anything to get me started, would anybody be able to help? Thanks I am trying for a javascript code that would ask for the excel file location when run, fetch data from two columns till eof in an excel file (MS Excel 2010), append it to an existing text file and upload the plain text file to an ftp location. The ftp username, password and location needs to be hard coded in the script. Is this possible? How do I use Javascript to loop through all the spreadsheets contained in 1 excel file? I am now at the stage where I can open the Excel file and find a value on 1 spreadsheet. Is there any way to detect if the workbook has multiple spreadsheets and then loop through all the spreadsheets to find a value? thanks! 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! Hello all, I'm trying to open up an internal link from my leftnav div into my content div. I used the following JS code from my book but im not quite sure how to make it all work. Any thoughts appreciated. Thank you Code: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<!--header script starts here -->
<script type="text/javascript">
window.onload = initlinks;
function initlinks() {
for (var i = 0; i < document.links.length; i++) {
document.links[i].onclick = setContent;
}
}
function setContent() {
document.getElementById("content").contentWindow.document.location.href = this.href;
return false;
}
</script>
<style type="text/css">
html, body
{
margin: 0;
padding: 0;
}
#container
{
width: 90%;
margin: 10px auto;
background-color: #fff;
color: #333;
border: 1px solid gray;
line-height: 130%;
}
#header
{
height: 60px;
background-color: #ddd;
border-bottom: 1px solid gray;
}
#leftnav
{
float: left;
width: 160px;
height: 380px;
margin: 0;
padding: 1em;
}
#content
{
margin-left: 200px;
border-left: 1px solid gray;
padding: 1em;
height: 380px;
}
</style>
<title>JavaScript</title>
</head>
<body>
<div id="container">
<div id="header">
<h1>JavaScript</h1>
</div>
<div id="leftnav">
<p>
<a href='#'>Load Content</a> <br /><br />
<a href='#'>Load Content</a> <br /><br />
<a href='#'>Load Content</a> <br /><br />
<a href='#'>Load Content</a> <br /><br />
<a href='#'>Load Content</a> <br /><br />
</p>
</div>
<!--Div to load content into-->
<div id="content">
<h2>Subheading</h2>
<p>
Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel erat volutpat.
</p>
</div>
</div>
</body>
</html>
Hi, I need to open a PDF file via a web page. Basically, I want to have a textbox where I type in a filename and then click submit and it will open that document. For example, I need to open a PDF document... I need to have a text box where I can input "test1" for example, click "GO" and it will add the "C:/test/" + textbox value + ".pdf" and open it in the browser. I could do it in PHP but this is going to run on a local machine with no serverside so I assume JS will be the way forward. Any ideas? Many Thanks MJFCAD You can see the website here with all the code to make it easier for you to diagnose what is happening: Code: http://www.fdfdaa.com/desktop/desktop.html When you go to the start menu and select anything on the left side, you will see that windows open 100% of the screen by default. I did that by adding maximized:true but that doesn't appear to be working for the icons on the desktop itself. If you click on one of those 4 icons on the desktop though, it isn't opening at 100% for some reason. You can see my classes file here as well: Code: http://www.fdfdaa.com/desktop/classes.js Any help will be greatly appreciated. Thank you for your time! Ok, newbie here. Like, REAL new. Anyway, used some script for an animated drop down menu from clarklab.net. I want users to click on menu to expand to sub's, but I can't figure out how to fix it from expanding every single one. I also want users to be able to close back up. Help? I am ready to jump. Thanks Here is the site, vertical navigation on left side: Here's ma' code Code: <script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript">
$(document).ready(function () {
$("ul.menu_body li:even").addClass("alt");
$('.menu_head').click(function () {
$('ul.menu_body').slideToggle('medium');
});
$('ul.menu_body li a').mouseover(function () {
$(this).animate({ fontSize: "14px", paddingLeft: "20px" }, 50 );
});
$('ul.menu_body li a').mouseout(function () {
$(this).animate({ fontSize: "12px", paddingLeft: "10px" }, 50 );
});
});
</script>
Code: <div class="container">
<div class="menu_head_nodrop"><p><a href="administrativeservices.html">Administrative Services</a></p>
</div>
<div class="menu_head_nodrop">
<p><a href="birthdeathcertificates.html">Birth & Death Records</a></p>
</div><div class="menu_head">
<p>Construction Programs</p>
</div>
<ul class="menu_body">
<li><a href="manufacturedhomes.html">Manufactured Homes Installation</a></li>
<li><a href="plumbingprogram.html">Plumbing Inspections</a></li>
<li><a href="healthyhomes.html">Healthy Homes</a></li>
</ul><div class="menu_head">
<p>Environmental Health</p>
</div><ul class="menu_body">
<li><a href="environmentalhealth.html">Beach Monitoring</a></li>
<li><a href="rabies.html">Rabies Control</a></li>
<li><a href="foodprotection.html">Food Service</a></li>
<li><a href="householdsewage.html">Sewage Treatment Systems</a></li>
<li><a href="Radon.html">Radon</a></li>
<li><a href="leadsafety.html">Lead Safety</a></li>
<li><a href="manufacturedhome.html">Manufactured Home Parks</a></li>
<li><a href="marinas.html">Marinas</a></li>
<li><a href="http://0052c90.netsolhost.com/nuisance.html">Nuisance Complaints</a></li>
<li><a href="privatewater.html">Private Water Systems</a></li>
<li><a href="poolandspa.html">Public Swimming Pools & Spas</a></li>
<li><a href="realestatesurveys.html">Real Estate Surveys</a></li>
<li><a href="rvparks.html">RV Parks & Campgrounds</a></li>
<li><a href="http://www.odh.ohio.gov/odhPrograms/eh/schooleh/sehmain.aspx" target="_blank">Schools</a></li>
<li><a href="tattooandbody.html">Tattoo & Body Piercing</a></li>
</ul><div class="menu_head">
<p>Health Education & Outreach</p>
</div><ul class="menu_body">
<li><a href="communityhealth.html">Community Health</a></li>
<li><a href="http://www.scrubclub.org/home.aspx" target="_blank">Handwashing</a></li>
<li><a href="healthyhomes.html">Healthy Homes</a></li>
<li><a href="leadsafety.html">Lead Safety</a></li>
<li><a href="lifeskills.html">LifeSkills</a>
<li><a href="schoolwellness.html">School Wellness</a>
<li><a href="smokefreeworkplace.html">Smoke Free Workplace</a></li>
<li><a href="teenpregnancy.html">Teen Pregnancy Prevention</a></li>
</ul><div class="menu_head">
<p>Nursing & Clinic Services</p>
</div><ul class="menu_body">
<li><a href="familypractice.html">Family Practice Services</a></li>
<li><a href="bccpinfo.html">Breast & Cervical Cancer Program</a></li>
<li><a href="childrenshealth.html">Sports & Work Physicals</a></li>
<li><a href="specialneedschildren.html">Children with Special Needs</a></li>
<li><a href="communicabledisease.html">Communicable Disease</a></li>
<li><a href="familyplanningclinic.html">Family Planning</a></li>
<li><a href="helpmegrow.html">Help Me Grow</a></li>
<li><a href="HIVAIDS.html">HIV/AIDS Testing</a></li>
<li><a href="homehealthcare.html">Home Health Care</a></li>
<li><a href="immunizationfaqs.html">Immunization/Shots</a></li>
<li><a href="leadscreeningandtesting.html">Lead Screening & Testing</a></li>
<li><a href="prenatalclinic.html">Pregnancy Testing & Assistance</a></li>
<li><a href="schoolnursing.html">School Nursing</a></li>
<li><a href="seniorclinic.html">Senior Clinic</a></li>
<li><a href="specialtyclinics.html">Outreach Clinics</a></li>
<li><a href="HIVAIDS.html">STD Clinic</a></li>
<li><a href="tbtesting.html">TB Testing</a></li>
</ul><div class="menu_head">
<p>Public Health Preparedness</p>
</div><ul class="menu_body">
<li><a href="publichealth.html">General Information</a></li>
<li><a href="medicalreservecorps.html">Medical Reserve Corps</a></li>
</ul><div class="menu_head">
<p>WIC</p>
</div><ul class="menu_body">
<li><a href="wic.html">WIC Services</a></li>
<li><a href="http://www.odh.ohio.gov/odhPrograms/ns/wicn/wic1.aspx" target="_blank">Learn More About WIC</a></li>
</ul>
</div>
I want to open a new tab "http://www.example.com/" when the user presses a key. How can this be done?
is there a way in HTML or Javascript to open a new window and force it to be a new Window, not a new tab? and also avoid popup blockers??
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.. 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 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 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. 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? Please help ... bit urgent I am creating a small automated system where front-end is html query form and back-end database is MS excel. both at local PC only & in a single folder. problem is like a survey form. continuous data entry, error correction, read/wite all these are included. I created a program upto first entry; but the second, third, ... entries and it is continuous. pl help me regards K.Kaniraj |
|||||||