Add new sheet client side? Fill from csv? Javascript?

M

MikeHolloway

This code works fine client side:

document.forms[0].HourlySpreadsheet.CSVURL
= "../../Counter/" + document.forms[0].tmpFileName.value;
document.forms0].HourlySpreadsheet.ActiveSheet.Protection.
Enabled = false;
document.forms[0].HourlySpreadsheet.ActiveSheet.Name
= "Hourly Data";
document.forms[0].HourlySpreadsheet.ActiveSheet.Cells
(2,4).Activate();
document.forms[0].HourlySpreadsheet.ActiveSheet.Rows
(1).Font.Bold = true;
document.forms0].HourlySpreadsheet.ActiveWindow.FreezePane
s = true;

If I add:

document.forms[0].HourlySpreadsheet.Worksheets(2).Activate
();
document.forms[0].HourlySpreadsheet.ActiveSheet.Name
= "Audit Events";
document.forms[0].HourlySpreadsheet.CSVURL
= "../../Counter/" + document.forms[0].tmpFileName2.value;

The second code does nothing. My ASSumption was that the
CSVURL data was loaded to the active sheet. What am I
missing?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top