Paste data to excel with formatting

3
votes

I have a web page that have:

  1. a table with columns & rows (using DataTables)
  2. a "copy" button that will copy the content of table (including header & data rows) into a clipboard using flash. (using DataTables's TableTools copy to clipboard)

If I press the "copy" button then paste to excel, the data will be fit perfectly into columns & rows. But with no formatting.

I have looked around within the js file & the flash. Looks like the correct way is to tweak on how to provide the data + formatting from the js.

Question: How to include the formatting data into the clipboard?

1
javascriptjqueryexcelwebdatatable

1 Answers

0
votes

Use range.pastespecial.paste:=xlPasteValuesAndNumberFormats

For more details look in the model reference: https://msdn.microsoft.com/en-us/library/ff839476%28v=office.15%29.aspx