Wrox Programmer Forums
Go Back   Wrox Programmer Forums > C# and C > C# 1.0 > C#
| Search | Today's Posts | Mark Forums Read
C# Programming questions specific to the Microsoft C# language. See also the forum Beginning Visual C# to discuss that specific Wrox book and code.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the C# section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 15th, 2006, 12:17 PM
Registered User
 
Join Date: Mar 2006
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default rendering .xls Excel files

I'm currently writing an application that compiles a lot of information to PDF, including Excel files.

I was hoping to find some way of rendering an Excel spreadsheet without using Excel. Let me explain:

All the products out there that print Excel to PDF, export Excel sheets to JPEG or BMP, export Excel sheets to PDF, display Excel sheets on the monitor, etc... or in ANY way try to render an Excel sheet use Excel to do it.

In other words, no program tries to guess what the Excel sheet looks like without physically using MS Excel to tell it what the sheet looks like.

I was wondering if anyone knew an exception to this rule. Is there anything out there that can render an Excel sheet as a graphic, PDF, or anything else that does not use Excel to tell it how to draw this image?

 
Old July 26th, 2013, 04:37 AM
Registered User
Points: 18, Level: 1
Points: 18, Level: 1 Points: 18, Level: 1 Points: 18, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2013
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi, here is one exception, this C# Excel component.
It has a really simple API and no dependency with MS Excel.

Here are the sample codes to convert excel file to a pdf in C# or to a image file format:
Code:
// Convert Excel (XLS) to PDF.
ExcelFile.Load("Workbook.xls").Save("Workbook.pdf");

// Convert Excel (XLSX) to PNG.
ExcelFile.Load("Workbook.xlsx").Save("Workbook.png");
 
Old February 28th, 2019, 03:44 AM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2019
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You can modify the report server to config to customize XLSX.

Unable to find pertinent walkthrough on steps to complete.
 
Old March 12th, 2019, 05:47 AM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2019
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am having trouble with a visualforce page rendered as xls. It was working fine for a year and now it stopped. The .xls file is generated and downloaded but shows up as a blank grey background with no content. I've tried making a simple test page with the same result. I have added contentType="application/vnd.ms-excel#ifacetimeapp.xls" to the page tag to accomplish this in the past. Was something changed in the spring/summer 16 releases ?




Similar Threads
Thread Thread Starter Forum Replies Last Post
Accessing csv, text(tab), xls files rahulsurya ADO.NET 0 November 6th, 2007 03:11 PM
convert PDF file to XLS for Excel crmpicco Classic ASP Basics 2 November 30th, 2005 05:51 AM
error in excel report rendering. hemantkanchan BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 0 January 5th, 2005 02:49 AM
Exporting access database to Excel .xls Squall Leonhart Classic ASP Databases 5 December 2nd, 2003 07:42 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.