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

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

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

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