Export Html table to excel and keep css styles

advertisements

I'm using excel web queries to export an html table (mvc view) to excel. How do I get it to carry across the css styles? If I set class="redLabel" it doesn't interpret that and make the label red. I have to use inline styles in my table for this to work. Any ideas?

As far as I know, most Office programs do NOT support included styling, but only inline styling.

It's likely that you'll be required to include your styling inline (exporting sucks, almost like mail styling).

Related Articles

Export HTML table for Excel does not work in IE

I will done export the HTML table to Excel is working fine in Chrome and Firefox but its does not working in Internet Explorer 10. var tableToExcel = (function() { var uri = 'data:application/vnd.ms-excel;base64,', template = '<html xmlns:o="urn:s

Export HTML table to Excel (XLS or CSV)

I'm trying to export HTML table content to excel. I saw this solution which worked but not as I expected it (because I can't choose which columns to copy, and it doesn't works with big tables). And another solution to copy by js and manually paste to

Export HTML table to Excel

I have HTML table on the ASP.NET MVC View page. Now I have to export this table to Excel. (1) I have used partial view (Inquiries.ascx) to display the table data from database (using LINQ to Entity) (2) I also have used UITableFilter plugin to filter

How to export html table to Excel or pdf to php

In my php page i have a table and if the user requires he has to export that table to excel sheet.. The code for displaying the table is: $sql=mysql_query("SELECT * FROM attendance WHERE (year = '" . mysql_real_escape_string($_SESSION['year']) .

Export HTML table to Excel using the page method

I have the following code on the client side for retrieving data from the HTML Table and then send it to the server through the page method: function dtExportToCSV(dataTable) { var elements = dtDataToJSON(dataTable); var headers = dtHeadersToJSON(tab

HTML link with fill and active CSS style does not work

HTML link with padding and CSS style active does not work in Google Chrome, Apple Safari, Opera, Mozilla Firefox. However, it works in Internet Explorer 8. Here is an example code. Try to click on Stack - link does not work, click on Overflow - link

Export html content to excel in javascript

I am exporting Html content to Excel and download the Excel in JavaScript. It works fine but my requirement is to download Excel without Grid Lines and also I want to render the content as my html shows in browser. Is there any options or suggestions

How do I export multiple html tables to excel?

I have a webpage that has 3 tables and I'd like to export all 3 of them to same excel file. I'd like each table in its own sheet, but having them all on the same sheet is ok as well. After some googling, all I've seen is exporting one table to one ex

JavaScript - exporting HTML table data to Excel

I'm trying to convert HTML tables to Excel, i have tried with a JavaScript function which converts a simple table to Excel, it is working fine. If I have multiple tables how will I be able to add all the table data into the Excel file. here's what I

export the HTML table to excel the file encoding

Ive got task to write code to export html table with headers to excel. What I came up with is serverSide code like this: Response.Clear(); Response.AddHeader("content-disposition", "attachment;filename=myexcel.xls"); Response.ContentTy

UTF-8 encoding when exporting the HTML table to Excel

I am trying to export an HTML table to Excel using javascript. This is the javascript code <script type="text/javascript"> var tableToExcel = (function() { var uri = 'data:application/vnd.ms-excel;base64,' , template = '<html xmlns:o=&q