Generating an excel file with EPPlus is failing

When I try to generate an Excel file using EPPlus, Excel give me the following error message: Excel cannot open the file 'myfilename.xslx' because the file format or file extension is not valid. Verify the the file has not been corrupted and that the file extension matches the format of the file. Here's my code: public ActionResult Index...

Convert XLSM to XLSX

I'm using the EPPLUS library to read data from Excel to create another file. Unfortunately it does not support the .XLSM extension file. Is there a nice way to convert .XLSM files to .XLSX file for the purpose of reading the file with EPPLUS? (using EPPLUS for reading would be nice because all my code is already written using it :) )...

Adding images into Excel using EPPlus

I am trying to add the same image multiple times into an excel file using EPPlus. I am using the following code to do so: Image logo = Image.FromFile(path); ExcelPackage package = new ExcelPackage(info); var ws = package.Workbook.Worksheets.Add("Test Page"); for(int a = 0; a < 5; a++) ws.Row(a*5).Height = 39.00D; var picture = ws.Dra...

GridView to Excel using EPPlus

I'm trying to create an excel sheet using the EPPlus's library. However, the output excel file does not relate well to cells of representing numbers. The code I'm using is: using (var pck = new ExcelPackage()) ExcelWorksheet ws = pck.Workbook.Worksheets.Add(string.IsNul lOrEmpty(SpreadsheetName) ? "Report" : SpreadsheetName); ws.Cells["B...

Is there a library or example for creating Excel (.xlsx) files?

I'm writing a Cocoa application and I'm trying to export to the Excel XML format (ISO/IEC 29500-1) which is basically a zip file with a bunch of xml files in it named with a .xlsx extension. I've tried generating apple script and using NSAppleScript to create the Excel file, which works, but is slow and the user has to have Excel installe...

Importing data into Excel using XML and Excel Templates

I am generating CSV data from a C# application. This can be imported into Excel easily but I need formatting applied to the file. One option is interop but the machine running this application will not have Office products installed so that is out. I've been told that XML can work with Excel templates and am looking for a starter example...

Wise PDF to Excel - 1.0

Wise PDF to Excel is a powerful and convenient application designed to switch PDF file into Microsoft Excel file, it supports different versions of excel files, including Microsoft Office Excel 2003, Excel 2007 and Excel 2010.

Illegal xml character breakes .xlsx file

Hi! I'm pretty new programming with POI, but I'm having a problem. I'm generating a xlsx file using SXSSFWorkbook. This file contains Facebook posts and comments from my pages. All comments are stored and treated as Strings. The problem is that, in some cases, some posts come with strange characters, as vertical tabs (ASCII control charac...

need help to generate excel file from ms-access

Hello all, Im new to this forum, need help on ms-access VBA code to generate excel file and the generated excel file should automatically go as attachment to a perticular person through outlook. details as follows i will enter first name,last name,id,email id in access database and vba code should generate excel file as follows first name...

Parsing Excel file without Apache POI

I know that we can use Apache POI to parse an Excel file and get data. But I heard of a strange thing that excel file can be passed in a similar way we parse CSV (Like just read the file from file Stream and separate each column value with a "comma" separator). When we parse Excel we have to use tab as a delimiter. Is it possible? If yes...

Stop Excel 2010 from appending .txt to file with existing extension

I think this problem may have to do with Windows 7 vs Windows XP. With Excel 2010 running under XP this does not happen. Under Win 7 running Excel 2010, when saving a spreadsheet as a tab delimited text file (.txt). Excel 2010 appends the .txt file extension to a file that already has an existing file extension. For my work I must save ex...

extracting multiple excelsheets into one

hi friends... is that possible to extract out all the data in second sheet from each of the excel file into new excel file? mean that i have a huge excel files in a folder, i would like to extract out all the second sheet from each of the excel file into new excel file.?? help :confused:...

Append data to a Excel file from a Template

Dear All, I have 2 excel files, One is just a template file and second excel file has actual data. I want user should not access actual data file directly, he would just fill template and click on Save button. Once save button is clicked filled data would get appended into second excel file. In other words - Second file would act as a dat...

Excel with Data Connection File

Is there any way to have Excel 2007 connect to a table or view in SQL Server without having to maintain a separate "Data Connection File"? I was hoping the connection string could be embedded within the Excel document. I would like to pass this Excel document around without having to send the Data Connection File with it. The only way to...

open excel source document in background when i open word document

I am working with a word document that has links to an excel workbook. I have tried this with task scheduler but it doesn't quite do what I need so I will play in this pond for a bit. Basically, I need a vba that will open the excel file when the word file is opened. The excel file already has a code that will refresh the data and then au...

Macro Needed to Rollup Mulitple Excel Files

I have multiple excel files that are structured identically and are in a folder. Each excel files data starts at d4 (multiple rows of data but all rows start on the subsequent d) I need a macro to take the data from all the separate excel files in the folder and create a single new excel file of all the data from the separate excel files,...

Asp.net/C# Error while exporting data from gridview to excel nd resaving the eidted excel

i have created an application that is used to export data from gridview to excel .... the data is succesfully exported to excel sheet the problem occurs when i try to edit the excel sheet and resave the same file again... it pops up an error message .xls may contain features that are not compatible with web page. do you want to keep the w...

Output to Excel using ExcelLibrary in c#

The following code outputs to a csv file using controller.file. I want to change it to input to an excel sheet (.xls) instead of a csv file. I a using this library from here to do this.. http://code.google.com/p/excellibrary/ as per this stackoverflow post.. Create Excel (.XLS and .XLSX) file from C# byte[] content; using (var ms = new Me...

UIDocumentInteractionController error opening large excel file

i'm using the UIDocumentInteractionController to show an excel file but this file is huge and contains 7 sheets. the first and second sheet appear correctly but when i tried to see the third sheet i got this: An error occured while reading the document. does anyone know why it occurs ?is the issue with the file ?i tried to open this file...

Excel found unreadable content in filename.xlsm'. do you want to recover.....

Hi, I've got a problem when opening the excel. I've been searching around this problem, however, it's not exactly what I'm encounter. I have an excel 2007 file which contain a lot of macros. File size is 100MB. This file is not developed by myself, it's post in the webpage and let the members of the page to download on daily basis.. I've

read excelsheet in azure uploaded as a blob

I am using FileUpload control of asp.net and uploading the excel with some data. I can't save it in some folder. I can have stream of excel sheet file or I can have Blobstream after uploading excel as a blob. Now I want to convert that excel sheets 1st sheet to datatable so how shall I do that? I am using C# .NET. I don't want to use Inte...

Read embedded Object in excel using java

I want to make one excel sheet which I need to send other for filling it. In the excel sheet , the other person fill his information and can also attach text/doc file with excel sheet.... I need to access that text/doc file .. Please provide me a solution . I am using Apache POI - HSSF api. Thanks in advance.

Unable to open large file in Excel

Our current application produces reports in an Excel format. The User is able to generate the report, however, when trying to open the file, the message indicates: Excel was able to open the file by repairing or removing the unreadable content. This user is able to run and open the file for this same report when the date range is only one...

excel ignores system list separator

I want to save an excel sheet as a csv file. I choose 'Save as', select CSV file format and click on 'Save'. When I open this saved file in textpad I see that excel used the ';' (semicolon) as delimiter for the cells. I searched google for this problem and it was said that the list separator in the regions additional format settings shoul...

Excel template in sharepoint - how to open as a new file from template?

I need to place an excel template in sharepoint and give people a link to it. I would like to prevent users from changing the template. There are couple of solutions: - revoke people sharepoint right to change the file, - keep the file checked-out to me. I also think about other scenario. Currently file is in .xlsm format (macro enabled...

One excel file pages will not print, other Excel files print just fine

I have one Excel file that I use daily that when printed from only gives blank pages. I can print the file to a pdf and then print the pdf just fine. What would cause just this file to have trouble printing? The print preview shows the page(s) to be printed but it only prints blanks. Is there a setting that may have been changed within th...

Merging multiple Excel files into tabs of one excel file without having to copy and paste?

Is there a way to merge multiple Excel files into tabs of one Excel file without having to copy and past? Say I have three Excel files called One, Two, and Three. I want to set them as sheets One, Two, and Three in one Excel file called Summary. I included the excel files. If anyone has the solution, I would greatly appreciate the help. O...

how to run VBA macro from perl code

I am new to perl & i am trying to write a module which would run a excel macro on a already open excel sheet. there is a code sniplet that describes how to run a macro from another excel sheet but i want the macro code as a subroutine in the same file. How to implement that? Can any one help? use strict; use warnings; use Win32::OLE;...

VB.net text -> Excel conversion (with extensive formatting required after conversion)

I'm creating a program in VB.net that does the following: At a high level I receive a file in email, put the attachment in a monitored folder, import the text file to excel, format the excel, and then email the excel file to a list of recipients. Here is my plan: Completed: Outlook VBA to monitor all incoming email for specific message. O...

concatenate a CREATE TABLE statement with my values from the first

i am trying to write a program in java where i would row of excel file and hold the fields name to create the SQLStatement. To be more specific i would like to create a table to store the data in a database where it will have as field the content of the first row of the excel file. I have a couple of excel files and for each of them i wou...

Nedd help in extract data from word file to excel.

HI, I want to extract data from word file to excel format attached word & excel file format in which i need to extract data from word to excel It will be of great help if i can do this. Regards, pagi Attached Files company- position- Profile Tracker.xlsx‎ (10.0 KB) sagarvikasdighe[3_3].doc‎ (46.5 KB)...

How to export MS Chart control to Excel

I have generated a chart in my web application (.Net 4.0) using MS Chart Controls. My requirement is to export the particular chart into an Excel file as an image. I have written the below mentioned code attempting to write the chart image to the excel file as a byte array. But it resulted some unknown characters in my excel file. (The by...

Problem in Excel 2011 (mac): "file.xlsx is already open"

I am using office 2011 for mac. I tried to copy a chart from excel to word. I failed to do this, and soon after Excel closed prompting me to either save the file or not. When I try to reopen it nothing happens, until I click on the file again. Then this message appears: "file.xlsx is already open: Reopening will cause any changes you...

Use Data from Combobox

Hello All, I am new to this forum as well as excel, I am learning to understand how this works I have a plan and am not sure how to execute it in excel, came across this wonderful forum and thought some excel GURU can make my life simple and help me with this. I have attached the excel file which has all the necessary information. Any hel...

Tell AppleScript to go to a specific window in Excel

I've got a script that pulls information from an Excel(Mac Excel'04) spreadsheet, and processes it through a local database. My problem(which is temporary, pending a dedicated scripting machine w/ Excel '08) is when I need to work on another spreadsheet in Excel. I want to ensure that the AppleScript continues reading data from the correc...

Unable to open an Excel File using VB .Net 2008

Hi, I am trying to open an excel file using vb 2008. This is what is happening I have a Module GlobalVariables.vb and the main code I have written in Form1.Designer.vb GlobalVariables.vb imports Excel = Microsoft.Office.Interop.Excel Module GlobalVariables public oExcelApp as New Excel.Application public oExcelWorkbook as New Excel.Work...

Macro to create email with refrence taken from excel sheet

Hi Guys, I want to creat a macro which take the input from an excel file and create and email in my outlook excel file will contain email...body Email send to and CC could you please help me in this i have attched a sample file. and macro shold run thorugh a shortcut key like pressing CTRL+U... Appericiate your quik response. Thanks Sam A...

Python File Download

I am having a problem and not sure if this is possible at all, so if someone could point me in the right direction. I need to open a file from a webpage, open it in excel and save the file. The problem I am running into the file name on the website has a file name ( not an active link ) and then it will have a "download " button that is n...

deleting rows from an excel file using c#

i am opening an excel file like this: Excel.Application xlApp; Excel.Workbook xlWorkBook; Excel.Worksheet xlWorkSheet; Excel.Range range; string str; int rCnt = 0; int cCnt = 0; xlApp = new Excel.ApplicationClass(); xlWorkBook = xlApp.Workbooks.Open("csharp.net-informa tions.xls", 0, true, 5, "", "", tru...

Repair corrupt excel files by Sanmaxi Excel File Repair

http://www.excel-file-repair.com repair excel corrupt files. It is widely used software to repair corruption in all corrupt excel files. Autor: kuldeepruhela Tags: software file files Añadido: 2013-05-22 15:15:48...