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
17
votes
3 answers

Can't open excel file generated with excelLibrary

I'm using excelLibrary to programatically create excel files but I get a file format error when I try to open the generated files in Microsoft Office Excel. I've seen this has been reported but there's still no answer about it. I use Office 2010 and…
mmutilva
  • 18,688
  • 22
  • 59
  • 82
3
votes
4 answers

Exporting datasets into multiple excel sheets of one excel file

I need to export two dataset's values in two excel sheets of the same workbook. My Query is like: //Dataset One: DataSet ds1 = new DataSet(); SqlCommand commandOpen = new SqlCommand("storedproc1", conSql); …
Sameep Baxi
  • 111
  • 1
  • 4
  • 17
3
votes
2 answers

How to create Excel sheet using DataTable and the ExcelLibrary?

I have data-table which contain no of column also with date with "DATE" datatype. I tried following option 1) 3rd part DLL- ExcelLibrary It works fine if there is no date column in dataset, else it use some dummy value like -65284 instead of…
dwan
  • 193
  • 2
  • 3
  • 11
3
votes
3 answers

Code to read from excel sheet is not working

I have the following code to read from a test file and print it on console but it's not printing any thing, I don't know how to chech the error its generating. I am using java, selenium, ie 10, win 8. public class Rowcount { public static void…
newLearner
  • 184
  • 2
  • 15
3
votes
2 answers

How to Freeze Header row in Excel using ExcelLibrary dll

I am using ExcelLibrary dll . I want to Freeze the Header Row .. Can any body suggest how I might do this? I have tried the following code.. Imports System.Data.SqlClient Imports ExcelLibrary Imports ExcelLibrary.SpreadSheet Partial Class…
Pravin Kumar
  • 693
  • 1
  • 9
  • 35
3
votes
0 answers

Modifying excel file using the Lite.ExcelLibrary for silverlight

Anyone knows if there is any way to modify a .xls file using the excellibrary? To explain more:- I'm working on a project that should generate a .xls file, read from the file, modify it and save it. I managed to generate, read and save the file, but…
DreamNet
  • 627
  • 3
  • 8
  • 24
3
votes
2 answers

Attach an XLS (Excel) file to Email

My application uses the intent method to send out emails to users, as a convenient way of exporting Excel spreadsheet data (created by the JExcell API). The file is contained on the SD card in a folder called records. The file I am attempting to…
Andrew S
  • 2,847
  • 3
  • 33
  • 50
2
votes
1 answer

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…
ZVenue
  • 4,967
  • 16
  • 61
  • 92
2
votes
2 answers

create multiple excels with multiple sheet using ExcelLibrary in C#

I want to export the data in multiple sheets with multiple excel files. As you can see in my image I want to generate sheets as ID changes and when ModalityId changes I want to create new excel. I have made code like this for this…
heer24
  • 47
  • 5
2
votes
1 answer

XlFileFormat for excel 2013 file

I am using Microsoft.Office.interop.Excel version 14.0. I see a lot off questions about which XlFileFormat you have to use for creating a Excel 2010 file. So my question is which XlFileFormat should i use to create a Excel 2013 file?
Maiko Kingma
  • 929
  • 3
  • 14
  • 29
2
votes
1 answer

Linking Two Excel Worksheets in One Drive / SharePoint

I'm trying to Link multiple Excel files and Upload to One Drive. while opening the Consolidated Excel file from One Drive through browser, displays warning as Links Disabled Links to external workbooks are not supported and have been…
Syed Nizamudeen
  • 440
  • 3
  • 7
  • 25
2
votes
1 answer

Copy date format cell to datatable excellibrary

I'm developing a program in C#, is a desktop application. I have a problem, I'm using excellibrary to open an excel and copy the data to a datatable, but I have a cell with date in format mm/dd/yyyy, but when i display the datatable in datagridview…
Randall Sandoval
  • 237
  • 1
  • 6
  • 21
2
votes
2 answers

How to I create and return an Excel File with a controller in MVC 4 in vb.net?

I am using ExcelLibrary enter link description here because I don't want to install Microsoft Office Excel (microsoft.interop.office.excel) Public Function ObtenerExcel() As ActionResult Dim workbook As New Workbook() Dim worksheet As…
EduardoUstarez
  • 603
  • 11
  • 22
2
votes
0 answers

ExcelLibrary Producing Unreadable Files

this is my first time using ExcelLibrary and I seem to have run into a little problem. I am saving a test file using the following code: Workbook workbook = new Workbook(); Worksheet worksheet = new Worksheet("Sheet 1"); …
TheGateKeeper
  • 4,420
  • 19
  • 66
  • 101
2
votes
1 answer

Set row height using excellibrary

I'm using excellibrary and I want to set a row's height or column's width. Sounds very simple, but I can't find a solution. How can I do that?
Gintas_
  • 4,940
  • 12
  • 44
  • 87
1
2 3 4 5