Copy data from excel into a web page.
 

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

Copy data from excel into a web page.
 

Expected browser platform and OS ?

Tim.


"Graham" wrote in message
...
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

Copy data from excel into a web page.
 

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" wrote:

Expected browser platform and OS ?

Tim.


"Graham" wrote in message
...
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

Copy data from excel into a web page.
 

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' contenteditablex</div
You should be able to paste directly into the div from excel .


Tim.








"Graham" wrote in message
...
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" wrote:

Expected browser platform and OS ?

Tim.


"Graham" wrote in message
...
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