Copy data from excel into a web page.

[Guest]

I have the case where i want a user to be able to select data from an excel
spreadsheet and copy that data.

Then i want them to come into the web application and click a button that
will get that information from the clipboard and display it in a grid in the
web page.

I need the data to be in XML so that i can use it to write to the database
when the user is happy with what they say.

Any help would be greately appreciated.

Graham

 

[Tim Williams]

Expected browser platform and OS ?

Tim.

 

[Guest]

Hi Tim,

This being run in a controlled environment so windows and IE.

I will be running the app in XSQL and XSLT, so Javascript will be
the scripting language.

Thanks

Graham

 

[Tim Williams]

Are you expecting only contiguous tabular data to be pasted ? Is there
any requirement to preserve formatting etc?

If you're working in an XP environment you could try looking at the Office
Web Components: the spreadsheet component may allow pasting from excel.

A very simple approach would be to have the user paste the data into a text
area and then parse it out into a table display using js. Once you have it
in a table then you can easily convert it to XML for posting to the server.


Or try this:
<div id='divTable' contenteditable>x</div>
You should be able to paste directly into the div from excel .


Tim.