0
votes
1answer
16 views

I can't find microsoft.office.interop.excel in .net application

For my work, I needed .net excel application for reading some data from excel sheet. I decided to use .NET dlls for my goal. I added the references.(from .COM tab, I don't know if I'm sure or not ...
0
votes
1answer
46 views

Excel Cell styling

I want to get a full styling in Excel sheet's cells like merging, coloring and font sizing. Now I am using Microsoft.Office.Interop.Excel library for this but I am getting confused to use it. this ...
0
votes
1answer
21 views

data accuracy loss adding values to excel cell c#

Morning, I have a accuracy problem working with excel cells. In the code below, I create an array with all my class components to make the data addition easier. All of them are strings, and I have ...
0
votes
0answers
9 views

.Net access Excel on Sharepoint with credential

I have a web page that need to read few Excel files (xlsm) hosted on Sharepoint with access restriction. And after reading those Excel files, the web page read few cells and do some aggregation and ...
-2
votes
0answers
36 views

Copy Excel content into another file using .NET and ACE

I need to copy the content that is in an Excel file (i.e. 'c:\temp\excel1.xlsx' , sheet1) into another excel file (i.e. 'c:\temp\excel2.xlsx' , sheet2). The code must run from a .NET - C# executable, ...
0
votes
0answers
14 views

Excel tile view customization

I am working in VSTO excel application. We have created tile view for Excel as referenced in the below url. visit How to tile two excel workbooks horizontaly using C# code The issue is if we open ...
0
votes
0answers
18 views

Excel throwing error HRESULT: 0x800A03EC [duplicate]

I have written the following generic excel code. It takes an array of excel sheet names (excelWorksheetName) and a param of data tables (dt) which correspond with the excel sheet names. It has ...
1
vote
5answers
51 views

Data truncated after 255 bytes while using Microsoft.Ace.Oledb.12.0 provider

I am reading an excel sheet using the ACE provider and certain cells contain data greater than 255 bytes. I tried changing the TypeGuessRows in the registry settings as well as setting the same from ...
1
vote
1answer
26 views

Can i use Microsoft.Office.Interop.Excel to create Excel file on the system where Micosoft Office pack is not installed

I am adding Microsoft.Office.Interop.Excel from the .net tab of the Add Reference option of Visual Studio to create Excel file.Every thing is working fine and i am getting quite good and fast Excel ...
0
votes
0answers
32 views

How to upload an excel file into sql server using C# .net

I have an excel report like this: A B C D E 1 ------- ------- 07/01/14 07/02/14 07/03/14 2 Location: Alief 3 Owner: 01354 4 Sales: ...
0
votes
0answers
46 views

Excel Range Copy Value vs Value2 Extension Method

I'm making an extension method to simplify copying range data from on worksheet to another. I want to specify a rectangular range and the top left cell of the target range. Keeping formating is ...
-2
votes
0answers
45 views

Process Entire Column/Row Excel C#

So I'm making an Excel addin and one of the functions I want to create has the ability to process each cell in a Range. My problem is if the user Highlights a column with maybe only 3 or 4 non empty ...
0
votes
2answers
76 views

Import from Excel file, process and Export to new Excel file [closed]

My requirement is to import data from Excel file, do some processing on data and then export the reformatted data to new Excel file. The imported data has about 200 columns and 200 rows. What will be ...
-1
votes
1answer
93 views

could not load file or assembly microsoft.office.interop.excel version 15.0.0.0 in windows xp

I am develop a program in VS2012 in Windows 8. I am reading an Excel file like this. xlWorkBook = xlApp.Workbooks.Open(fileAddress, 0, true, 5, "", "", true, ...
1
vote
1answer
42 views

Export Different Sheets in one excel file to different pdf files?

I have an excel file which has 10 sheets. We can use below to export the entire excel file to one pdf file. ExportAsFixedFormat(Microsoft.Office.Interop.Excel.XlFixedFormatType.xlTypePDF, outputPath, ...
1
vote
2answers
53 views

C# generated excel file - issue with special chars

Firstly, here is my code: DataTable usersReport = reportsService.GenerateUsersReport(); var grid = new GridView(); grid.DataSource = usersReport; grid.DataBind(); Response.ClearContent(); ...
0
votes
2answers
95 views

Limitation when exporting data to an Excel spreadsheet

I know this question exists, because it's mine and I put up 500 bounty points on it: Exporting C# report to Excel when there are more than 5K lines The answer got me over the hump (to some degree) ...
1
vote
1answer
64 views

Single RegEx expressiong to decode CSV with embedded dobule quotes and Commas

I have lots of CSV data that I am trying to decode using regex. I am actually tried to build on an existing code base that other people/projects hit and dont want to risk breaking their data flows by ...
0
votes
2answers
80 views

Reading decimal value from an Excel cell (in C#)

When reading values from Excel cells that contain decimals, I am running into the following issue: If I enter 9.95 in the cell in Excel, CellValue.InnerText in C# returns "9.9499999999999993" How can ...
1
vote
0answers
14 views

How can I append an excel row to sheetData by copying the previous row's formatting to it?

I am populating an excel sheet that has formatting applied on it by using OpenXML. When I open the excel sheet form Excel, it complains about it and RECOVERS. When check the recovered version with ...
0
votes
1answer
32 views

Exporting (rdlc) report to excel

I have a 1 page rdlc report which exports fine to pdf, but when I export it to excel it divides the report into 2 pages horizontally in print preview as if the report width is larger than the page ...
0
votes
0answers
19 views

Excel cell value becomes DBNull when read with OLE

I have an excel sheet that I am reading in. One of the columns contians names of departments, like "$.30 stuff". Notice how the value starts with a dollar sign. This is a problem as all those values ...
0
votes
0answers
23 views

List all Excel Add-ins in a client machine

Problem: I want to list all Excel add-ins (not COM add-ins) of every Excel version installed on a machine. Could you please give my any clue or suggestion? What I have done I've tried getting the ...
1
vote
1answer
47 views

Extracting/Validating Excel Data [closed]

I need to extract and validate data from multiple, uniform excel workbooks/worksheets. I was thinking of using F# with the interop libraries to open and extract data cell by cell and F# records with ...
-1
votes
1answer
35 views

VSTO Worksheet change event always return numeric values in Double?

In VSTO Worksheet change event/Range change events contains a parameter "Target" of type Range, the Target.Value is always of type double and has value with decimal. Whereas the same in VBA has type ...
0
votes
0answers
68 views

Excel dynamic operations can only be performed in homogenous appdomain error

The company I work for has the option to create plugins for our main product. I am currently working on a plugin. The plugin needs to read in from an Excel file. Part of my plugin tries to get a ...
0
votes
0answers
50 views

npoi 'Sheet' type or namespace could not be found

This seems like a super simple issue to resolve. The type or namespace 'Sheet' is simply not there, so I get the red underline with the above message. I have included: using NPOI.HSSF.UserModel; ...
-3
votes
1answer
25 views

How can I unzip Office Open XML file in C# and modify its data and re-zip again?

From a console application written in C#, how can I : extract an Office Open XML file, Obtain the data part of it modify the data and re-zip it again My motivation is to save an excel file with ...
0
votes
0answers
29 views

Cell formatting error when exporting to Excel

I have a Class to export a generated report to Excel, and I have a cell which contains duration formatted as hh:mm:ss or d.hh:mm:ss (i.e.: 67:43:34 or 2.19:43:34) but when I export it to Excel it ...
0
votes
1answer
52 views

CSV (or excel) parsing ; eliminate empty column

I am using TextFieldParser class to parse the file. I want to eliminate or ignore complete column if "entire column" is empty (which means single empty cell of a perticular row should be considered) ...
0
votes
0answers
40 views

Get data with autofilter

I'm stuck on this problem since many hours. The aim is to get lines from my Excel with a filter. Here is my code, rangeXL = xlWorkSheet.get_Range("M5:M82", _M); rangeXL.AutoFilter(2, "MILITARY 1", ...
0
votes
1answer
35 views

VSTO Compile Error in Hidden Module: Clipboard when using Excel.Range get_Range

I have been working up an Add-In to process data out of Excel files sitting in a directory. My program has run successfully in production under a number of scenarios, so I know my code is generally ...
-1
votes
1answer
22 views

Public member 'get_Range' on type 'Worksheet' not found

I am trying to use the code in below link. It is throwing the above exception at Dim aRange As Range = ws.get_Range("C1", "C7") http://msdn.microsoft.com/en-us/library/ms173186(v=vs.80).aspx Excel ...
0
votes
0answers
24 views

How to programattically stop and re-run the excel macro using vb.net?

I have an excel with which sheet3 have a macro which calculate the data present in sheet1 and sheet2 and fill the data in sheet3. Programmatically I try to populate the sheet1 and sheet2. For large ...
0
votes
2answers
22 views

How many instance context can be created for per call mechanism in WCF

I'm in a process of implementing a WCF service, wherein the service will be hit by many requests at a time. After getting a request the WCF service would open an excel file to read data using Interop ...
1
vote
0answers
22 views

Save interval in PowerPoint Application

I need to set AutoRecover interval every 5 minutes for PowerPoint. For Word: Microsoft.Office.Interop.Word.Application App = new Microsoft.Office.Interop.Word.Application(); App.Options.SaveInterval ...
0
votes
2answers
84 views

error while exporting to excel data : ' ', hexadecimal value 0x07, is an invalid character using c#

I have got strange problem when I try to export data in kendo ui grid to excel ..... Error : An exception of type 'System.ArgumentException' occurred in System.Xml.dll but was not handled in user ...
0
votes
1answer
62 views

The Archive is either in unknown Format or Damaged using Dotnetzip libray to zip file

I am using below code to zip the memory stream on the fly dynamically and creating excel file inside that zipfile .....using dotnetzip dll ...... public ActionResult ExportToExcel() { ...
1
vote
2answers
71 views

How to zip Excel file before it is downloading using Open XML?

I am using below code to create and it will show user prompt to user whether the user can able to save or open or cancel a excel file..... I am successfully able to download the file but I need to ...
-1
votes
5answers
69 views

C# write data in next column special character

I am writing the data from sql table and exporting to the excel file but problem is coming is data is coming in only one cell with \ symbol between all the data. which special character i should use ...
0
votes
0answers
41 views

Lost focus issue when using WPF and WindowsInteropHelper

I have a problem with hosting a WPF window inside Excel. What we want to achieve is a window similar to Excel 2013 chart icons next to the chart when chart is selected. The normal logic is already in ...
1
vote
1answer
58 views

Copy table from Word then paste to Excel using VB.NET

I'm copying a table from Word then pasting the copied table in an Excel file: tbl.Range.Copy() oSheet.Activate() rng = oSheet.Range("A1") rng.Activate() ...
-2
votes
1answer
145 views

how to import xls to database with asp.net 4.0 with c#

I just want to make xls mapping facility with asp.net 4.0 with C#. I just want to import all details from Excel sheet1 to database. Here I am binding one repeater which have text box here user can ...
0
votes
1answer
65 views

Reading & Writing Password Protected Excel Files in Azure

Is there a way (preferably an official Microsoft API) to read the contents of and generate password protected / encrypted Excel documents using C# .Net Framework in an Azure hosting environment? ...
0
votes
1answer
49 views

Import CSV where header not top row

I have a client where I import the data direct from a CSV however some of their Excel sheets start with say the company logo and generic text. These files are also sent to their third parties so we ...
0
votes
1answer
44 views

Getting Started with VB.net for Excel [closed]

I have written an add in for Excel in VBA, but I would now like to convert it to VB.Net. I have been looking at VB.net tutorials and I read this but I am still confused on getting started. I have ...
0
votes
2answers
75 views

Fastest Way of Multiplying Arrays in Excel VBA and .NET

I am trying to multiply arrays as quickly as I can. There will be very large arrays, multiplied a lot of times. I have the below code which uses a nested loop, is there any faster way of doing this? ...
0
votes
4answers
60 views

parse excel file best practise

I am facing an issue in parsing excel file. My file has more than 5000 rows. When I parse it, its taking ages I wanted to ask if there's any better way to do so. public static ...
0
votes
0answers
28 views

Excel add-in focus issue

I'm developing an add-in for Microsoft Excel. I have a button which creates a form for the additional parameters input. I'd like the user to be able to select a range as one of the additional ...
0
votes
1answer
69 views

I want to open an excel file and wait for user to edit and save it

I want to open an excel file and wait for user to edit and save it, and then i use the data. I am using this code : string tempFileName = "test.xlsx"; MemoryStream ms = ...