StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I think you need to provide a little more information..</p> <p>Off the top of my head, you could approach this a number of different ways :</p> <p><em>1)</em> MS Office Automation - Using javascript you could open Excel, open the 'correct' document and then insert the particular data in the cell.</p> <p><strong>Issues with this method</strong> </p> <p>You will need to ensure that your site is in the trusted sites list in IE to perform office automation. This may not be possible unless you are writing an intranet application.</p> <p>I've only used automation in IE before, it may not work in Firefox.</p> <p>It relies on the user having Excel installed and the correct file downloaded to their computer and available.</p> <p><em>2)</em> Roll your own Excel document - Probably easiest if your users version of Excel supports xml worksheets, Open the excel sheet server side, then using something like XPath queries find the relevant cell in the worksheet and insert your data. Stream the sheet out to the user as part of the HTTP Response.</p> <p><strong>Issues with this method</strong> </p> <p>The spreadsheet will always be from the server copy, unless you provide some mechanism for the user to upload their spreadsheet first. This has a whole raft of issues associated with it though.</p> <p><em>3)</em> Purchase an Excel Spreadsheet producer application - There are a number of programs out there which have wrapped up the process of creating 'true' (i.e. .xls) spreadsheets into nice easy to use .dll libraries.</p> <p><strong>Issues with this method</strong> </p> <p>$$$ Involved.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload