Stack Overflow
Stack Overflow

Questions tagged [excellibrary]

.NET library for Excel files manipulation

Native .NET solution to create, read and modify Excel files without using COM interop or OLEDB connection.

Project page: https://code.google.com/p/excellibrary/

67 questions
0
votes
2 answers

DataGridViewS export to excel sheetS

I want to export all my DataGridViews in one Excell document. For every DataGridView there shoud be a own sheet in the Excell File. But with my code i only recive the Error: System.Runtime.InteropServices.COMException: HRESULT: 0x800A03EC" I think…
m4gn1f1c4nt
  • 188
  • 4
  • 15
0
votes
1 answer

Export test results to excel using Robot Framework and Excellibrary

I'm new to Robotframework and I've been trying to export the result of my test to excel, but I couldn't get the correct loop for writing the data to excel. the logic works that every time the element is present in the page, it will be log to the…
Justine
  • 105
  • 1
  • 17
0
votes
0 answers

error occur while uploading excel size about 2.5mb in form page

I'm reading the excel file in php using excel library. Its showing error after uploading. Error like Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 8388608 bytes) How can I solve this issue.
user7714345
0
votes
1 answer

Best way to display and edit an Excel workbook on a web page

Purpose - I want to display an excel workbook (Macro) on a web-page in Angular 2-4 project. In an angular application I want to allow use to see an Excel workbook (Macro) data, and user must have the ability to edit it on the web page it self. This…
Tarun Rathore
  • 11
  • 3
0
votes
1 answer

Differences in versions of excel library in c #

I added the reference Microsoft.Excel.16.0.Object.Library to be able to process in Excel. However, the program I wrote is giving errors to other computers. Because their computers have older versions of this library. Can I make my program workable…
Alihan AYDIN
  • 31
  • 3
0
votes
2 answers

How to create and put data in excel file in Robot Framework?

I want to create an Excel file and add input data into it using Robot Framework. So I added the Excel Library. Here's the code I use, I got an error message saying IndexError: list index out of range So I commented the 3rd line and got the column…
Narek Hakobyan
  • 107
  • 2
  • 4
  • 13
0
votes
0 answers

How to export DataSet values to Excel using EPPlus?

Currently I'm working with ExcelLibrary.dll The problem with ExcelLibrary is that it makes corrupt excel files if data is less or excel size is less than 6kB. So I am switching to EPPlus dll. Currently my code is: DataSet dsNewDataSet =…
Sameep Baxi
  • 111
  • 1
  • 4
  • 17
0
votes
1 answer

Exporting image into excel in javascript

I want to export my html page into excell sheet which contains some svg charts and html tables. I searched a lot and couldn't find any solution in javascript. I could find a php solution in this. Only thing i found is a node module(here) which i…
akhil
  • 277
  • 3
  • 8
0
votes
2 answers

Create Excel file with ExcelLibrary

I use ExcelLibrary to create an excel from a DataSet. I use the below code to create a DataSet and create Excel. DataTable dtTable = new DataTable(); dtTable.Columns.Add(new DataColumn("name", typeof(string))); DataRow dr = dtTable.NewRow(); dr[0] =…
SajjadZare
  • 2,487
  • 4
  • 38
  • 68
0
votes
1 answer

Unable to open excell sheet which created by c#

I have created a excel sheet with the help of creating simple excel sheet in c# with strings as input link. It works fine the error when we open the saved excel sheet it shows message box like "excel found unreadable content in "sample.xls". Do you…
Neena John
  • 3
  • 5
0
votes
1 answer

Open file in share mode using excellibrary

I am using excellibrary to process excel files. Right now to open the file I am using ef = Workbook.Load(file) But if that file is opened somwhere else in another application when I try to access it I get the message: The process cannot access the…
user2824519
  • 43
  • 1
  • 1
  • 6
0
votes
1 answer

getting column count per work sheet Excell Library

I am using the ExcelLibrary package. Was wondering how to determine the amount of columns per work sheet?. var workbook = Workbook.Load(fileToValidate); foreach (var v in workbook.Worksheets) { //coulmn count for each sheet }
Arianule
  • 8,811
  • 45
  • 116
  • 174
0
votes
1 answer

What's wrong with this Excel code involving IFs?

=IF(B33=I33,K33,IF(B33=I34,K34,IF(B33=I35,K35)))*1000+(D33)/(C33) The code works fine as this: =IF(B33=I33,K33,IF(B33=I34,K34,IF(B33=I35,K35)))*1000+(D33) But I want to afterwards divide the figure by the value in C33. I have tried multiple ways…
Kevin
  • 1
0
votes
1 answer

Excel Library possible integer overflow

I am using Excel Library - http://code.google.com/p/excellibrary/ - To generate an excel 2003 spreadsheet. Everything works fine except when some big values are used. These are some reference numbers that are used by a client and I simply need to…
Kami
  • 19,134
  • 4
  • 51
  • 63
0
votes
3 answers

DateTime is rounded up to the next day using ExcelLibrary

The datetime I'm writing to Excel always get rounded up to the next day: workSheet.Cells[0, 0] = new Cell(DateTime.Now, new CellFormat(CellFormatType.DateTime, @"HH:mm:ss")); In the output Excel file the cell gets this value: 29/09/2013 …
Eduardo Brites
  • 4,597
  • 5
  • 36
  • 51
1 2 3
4
5