0

I want to copy a selected range from SpreadsheetGear Worksheet to Clipboard and then to MS Word.

Off course, I want to preserve all formating (colors, column widths . . .).

I guess I have to put it in the Clipboard in HTML format, but how do I get from SpreadsheetGear to HTML?

gajo357
  • 958
  • 12
  • 22

1 Answers1

1

SpreadsheetGear does not support converting worksheet data into HTML markup. The IRange interface contains enough information about cell formatting (IRange.Font/Interior/Borders/etc) that you could probably build your own routine to generate a similar representation of the data in an HTML table, then copy this data to the Windows Clipboard.

Tim Andersen
  • 3,014
  • 1
  • 15
  • 11
  • Somehow I hoped that people had need to copy some cells as table to MS Word and that I wouldn't be the first. You're basically saying that I have to do it manually? – gajo357 Mar 09 '15 at 08:40
  • Since there is no built-in support for converting cell data to HTML (or any other format that would be accepted by MS Word), yes, you would have to build your own routine to do this. – Tim Andersen Mar 09 '15 at 15:42