export-to-excel

Generate an Excel XML document in Asp.net MVC Web Site

I have an ASP.Net MVC site that generates a Microsoft Excel 2003 XML formatted spreadsheet. The spreadsheet looks good, the controller and views both work, but the file won't open in Excel. It opens in the browser because it is an XML document. I tried changing the ContentType to be the Excel XLS format (application/excel) and that ma...

CSV files and multi line text cells

Hi, I am generating a simple csv file using php. The file contains some user's personal data. When I open the generated file in office, the addresses are not displayed in full height. I have to double click on the cell for the address to be shown fully (in full width and height) otherwise I can only see the first word/number of the addre...

Export MS Charts to PDF and Excel

Hi I need to export a few (could be just one or more than one) Microsoft Charts to a PDF and Excel. It needs to happen on a button click and the charts should be directly exported to a PDF without getting rendered onto a web page. Environment used: ASP.NET Please suggest the approach to achieve this. cheers ...

Export SSRS 2005 report to Excel 2007

Is there any way to export a SSRS 2005 report to Excel 2007 (.xlsx) instead of Excel 2003 (.xls)? ...

Format an Excel column (or cell) as Text in C#?

I am losing the leading zeros when I copy values from a datatable to an Excel sheet. That's because probably Excel treats the values as a number instead of text. I created the worksheet in C# and I am copying the values like so: myWorksheet.Cells[i + 2, j] = dtCustomers.Rows[i][j - 1].ToString(); How do I format a whole column or each ...

Export Core Data information to Excel Sheet

I want to have an iPhone app where the user can export the data held by the application to an Excel spreadsheet (as well as a host of other formats). So the idea is that each entity would be a new row in the sheet, with the attributes being different columns. Is this possible? ...

Importing and Exporting atendees in a Sharepoint Meeting Workspace (WSS 3.0)

We're using workspaces (tied to calendar entries) for our meetings. It looks like attendees have to be added individually, on a per meeting basis. Is there an easy way to import the attendees (from excel, or a text list). Importantly we'd like to import them all at once, not have to add each person individually to each meeting. A sim...

export datatable to excel, value 3E2 become 300, supposed to be text 3E2

I am converting datatable to excel using the following code: public static void ExportDataTabletoExcel(String fileName, DataTable thetable) { if (thetable != null) { //clear anything in io buffer HttpContext.Current.Response.Clear(); //set to excel for to save file. HttpContext.Current...

Why can't I generate Excel file through cURL/PHP?

Hi there, I'm trying to use a post form to generate an excel file after choosing which data to grab from a MySQL database. I'm using cURL because I essentially want to double-post: first to save any settings of which fields are being used, and second to generate the Excel file, all with one button. I have a PHP page set up with the cor...

Issues exporting an Excel file from Crystal Reports

I am having an issue exporting Crystal Reports into an excel file. I tried both options of exporting the Excel data AND exporting as an excel file. When i export my Crystal Report as an excel file, i cannot sort any of the fields in my excel file. When i export the report as just the excel data, when i open in Excel, the headers are re...

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 the records (Ex: http://gregweber.info/projects/demo/flavorzoom.html ) (3) At any po...

Problem copy+pasting CR+LF into an excel spreadsheet need soft paragraph (Alt+Enter)

I'm trying to copy a table that is created in our software into an excel spreadsheet. Some of the title headers in our application are too big to fit in a column so they are separated by a #13+#10 (CR+LF) so they sit on the next line. e.g. Strain SpikeConc Spike ng/g dpm/g ------------------------- Blah 20.0 5...

Using OleDB to update cells in preformatted Excel Template file

StringBuilder sbExcelFileConnStr = new StringBuilder(); sbExcelFileConnStr.Append("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="); sbExcelFileConnStr.Append(sFile); sbExcelFileConnStr.Append(";Extended Properties=\"Excel 8.0;HDR=No;\""); OleDbConnection xlConn = new OleDbConnection(sbExcelFileConnStr...

How to Export data to Excel using LINQ to Entity?

Hi I have the data coming from Entity Data model table on my ASP.NET page. Now I have to export this data into Excel on button click. If it is using OLEDB, it is straight forward as it is here: http://csharp.net-informations.com/excel/csharp-excel-oledb-insert.htm Here is my function to read data from inquiries table: var model = fr...

generating excel documents with RUBY

I need to generate excel documents with ruby (from rails) on a Linux Machine. I know of Spreadsheet::Excel, but it doesn't support formulas, and uses a pretty old format.. Is there any other option, not necessarely free or opensource, that is a bit more powerful? thanks ...

Exporting multiple page headers in crystal reports (in visual studio) to Excel

I'm having a heck of a time trying to manipulate my reports so that when i do a data-only excel dump, excel can recognize page headers. I was wondering two things. 1.) Is there any way to change excel export options in Visual Studio? I know you can do this with Crystal Reports standalone...but unfortunately my project requires the us...

Import tool Excel CSV...

I need an import tools for a web app. I've been looking around and found some, just not sure about their stability. I'm using the Zend Framework for part of the project and was hoping I could find an import tool there, since I already have the framework, but couldn't see one...am I looking in the wrong place? I would like the web us...

Excel Range.BorderAround(), Border is always black.

This is the code I am using: rngData.BorderAround(Excel.XlLineStyle.xlContinuous, Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin, Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexNone, System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.FromArgb(178, 178, 178))); The border color is always bl...

export outlook 2007 mail folder and subfolders to csv

What's the best way to export mail from an Outlook 2007 folder to a CSV file? I would like to include mail messages within subfolders as well. The built in csv exporter does not allow the option to include subfolders but otherwise does exactly what i want. ...

What's XLSHTML?

What's XLSHTML? I want to generate, as simply as possible, a file which will open in Excel when a user double-clicks it, and which has some minimal styling. XLS meets my user requirements, but it's not easy to generate. CSV is easy to generate but has no styling. HTML is easy to generate and has styling but won't open in Excel when d...