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
2
votes
4 answers

How to show save as dialog box in Asp.net 2.0 C#?

I'm using ExcelLibrary to generate dynamic excel sheet. Which works perfectly. Code //create new xls file string file = Server.MapPath("Discussion_Board_Report.xls"); Workbook workbook = new Workbook(); Worksheet worksheet = new…
HardCode
  • 2,025
  • 4
  • 33
  • 55
2
votes
1 answer

how to add dataset to worksheet using Excellibrary

I have to add multiple worksheets in single file ..i can not find any way to add dataset to worksheet but i know how to add worksheet
gill chetanpal singh
  • 23
  • 1
  • 3
1
vote
2 answers

Why the date is coming like 434242 instead of proper date after exporting to excel?

I am using this to generate a report and export it to excel. ALTER PROCEDURE [dbo].[USP_DaysReport] @Week int= 50, @Year int= 2019 AS BEGIN Declare @YearText varchar(4) Set @YearText = @Year Select Emp_ID…
scaryghost
  • 77
  • 8
1
vote
0 answers

How to write data into a xls file with Google Code's ExcelLibrary Library without overwritting already written data

I am trying to write excel .xls files in c# by the use of the Google Code "ExcelLibrary". I want to write lines without writing over the data that is already in the spreadsheet. Any ideas on how I can do this? If there is a better library that I…
Faiq Ashraf
  • 49
  • 6
1
vote
1 answer

Keep uniqiue email addresses in Excel

I have a spreadsheet which lists the data of 2,000 people from multiple databases. My spreadsheet lists duplicate email addresses because for example - they may have given their personal address in one database and their personal and work address…
Jenny
  • 13
  • 3
1
vote
0 answers

Exception when I try to load file, unable to read beyond the end of the stream

I try to read an RTF file and send text for this to Excel file. I do this: Byte[] rtf; using (FileStream stream = new FileStream(Server.MapPath("/1.RTF"), FileMode.Open, FileAccess.Read)) { int size = Convert.ToInt32(stream.Length); rtf…
Alexandr Docker
  • 75
  • 1
  • 9
1
vote
1 answer

Export empty DB values to Excel

I am trying to export a datatable that I filled from a query, however I am getting an exception with the message "Invalid cell value" at the last line. This only seems to happen when the column contains null values. How can I modify my datatable to…
Emanuel
  • 11
  • 2
1
vote
0 answers

Get image type cell from excel

I am reading data from excel sheet containing image in one cell of each row. I have successfully read all data except image type of cell in C#. I am using Interop.Excel library Here is my excel sheet format:
Amna
  • 603
  • 7
  • 30
1
vote
2 answers

I'm trying to insert an image into an excel document using ExcelLibrary with Picture and CellAnchor and the image doesn't display

I trimmed out quite a bit so if there is context missing sorry, I'll edit. I'm not getting any errors and the Picture does seems to get added to the workbook object... I've also tried just inserting into a new cell(), but when I get to saving to…
user1040975
  • 420
  • 5
  • 16
1
vote
0 answers

ExcelLibrary - OutOfMemoryException when trying to open an Excel spreadsheet

I'm getting an error when trying to open an Excel Spreadsheet. I am using ExcelLibrary in Visual Studio 2015 and Excel 2010. Am I doing something wrong? It errors at line 3. OutOfMemoryException was unhandled An unhandled exception of type…
Taylor Swift
  • 242
  • 2
  • 17
1
vote
1 answer

ExcelLibrary throwing Unauthorized Access Exception when attempting to create

As the title describes, my program is throwing an UnauthorizedAccessException when attempting to create an Excel file with the ExcelLibrary Library, which is strange given my computer hasn't got any restrictions regarding that. My code: using…
OrangeWall
  • 79
  • 1
  • 8
1
vote
1 answer

Error when adding New Excel.application in VB .NET

For a project I have to be able to read infromation from an Excel sheet and then pass that information on to a PLC. Sadly I have a problem when I use 'Dim App As New Excel.Application' For some reason this make my application crash before the form…
ProgrammingRookie
  • 53
  • 2
  • 11
1
vote
1 answer

How to set column width of excel sheet

I am using ExcelLibrary for creating excel sheet. I need to increase width of some columns. Is there any way to achieve this? var ObjWorkBook = new Workbook(); var ObjWorkSheet = new Worksheet(ObjDataTable.TableName); ObjWorksheet.Cells[0, 0] = new…
Rasmita Dash
  • 917
  • 5
  • 15
  • 28
1
vote
1 answer

How to bring data from database to excel sheet?

I am trying to generate a excel sheet from database(sql 2008). I have wrote below mentioned code but it not working. Please help me to improve my code. below my sample code protected void generate_Click(object sender, EventArgs e) { …
Semil Sebastian
  • 111
  • 1
  • 5
  • 18
1
vote
5 answers

Buffer cannot be null error when opening excel file?

I am using excel Library to open a spread Sheet and read its contents, I am using this library over the interop library as the interop library causes issues on the server machine i hope to host on. https://code.google.com/p/excellibrary/ using…
Pomster
  • 14,567
  • 55
  • 128
  • 204
1
2
3 4 5