Importing Table from Excel to Word.

[princraiParticipant]

Hi Eric,

I have an scenario where we want to import excel table to word . Maybe either as openxml or as html. Can you let me know if there is already a way I can get it done. Maybe if we can convert it in html and then use it to insert into word.

Thanks,
Prince

[Eric WhiteKeymaster]

Hi Prince,

I believe that the best approach is to convert to HTML, and then convert to DOCX using HtmlToWmlConverter, a module in Open-Xml-PowerTools.

To convert your XLSX to HTML, you might start with the SmlDataRetriever module in Open-Xml-PowerTools. This module retrieves the data from a named range, a table, or a range, and outputs XML that includes the display value and the formatting information.

SmlDataRetriever: Better Approach for Retrieving Spreadsheet Data

Cheers, Eric

[fifa1234Participant]

The new Kinguin calendar consists of:Pawel “innocent” MocekGrzegorz “SZPERO” DziamialekMichal “MICHU” MüllerMikolaj “mouz” KarolewskiJacek “Minise” JeziakSame Penguin, Altered Results?Kinguin’s antecedent attack into the apple of able Counter-Strike showed able signs of CSGO Keys an entertaining–and conceivably even beautiful–failure. In May of 2015, afterwards weeks of rumors about an all-star all-embracing lineup, Kinguin appear the signing of a CS:GO roster. They had not accumulated an ‘ordinary’ team, in any faculty of the word. It was an all-embracing lineup–language barriers be damned–made up of flashy, highlight reel aimers: Mikail “Maikelele” Bill, Alexander “SKYTTEN” Carlsson, Norwegian CSGO Skins vard “rain” Nygaard, Adil “ScreaM” Benrlitom, and Portuguese adept Ricardo “fox” Pacheco.It was the affectionate of agenda that you’d body in your arch backward at night.

[DevParticipant]

Hi Eric,
I do not know if this issue is discussed before. I have a Spreadsheetdocument created from a stream. I am trying to preview the excel file on the browser. For that, I am converting the Spreadsheet document to HTML, with the help of SmlDataRetriver. I could not find any documentation on how to proceed further using SmlToHtmlConverter.
htmlText = SmlToHtmlConverter.ConvertTableToHtml(document, new SmlToHtmlConverterSettings(), “Sheet1”).ToString();
This is giving me an error
ArgumentException: Table not found
Parameter name: tableName
Can you please help me with this.

[Author]

Posts