.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/
Questions tagged [excellibrary]
67 questions
1
vote
0 answers
C# Excel Interop sorting data in excel sheet
I am using C# and wish to sort some data based on two columns. I have looked at various pages on the internet and have come up with the code below. The issue how ever is that the code does not compile.
I'm using Excel 2013 & in .Net the Microsoft…
mHelpMe
- 6,336
- 24
- 75
- 150
1
vote
3 answers
C# modifiing Excel files, keeping the style
I have an excel - file that works as a template for data to be generated. I need to modify this Excel-Sheet, duplicate it a few times and add data to it.
I tried using excellibrary from nuget the following way:
Workbook tmpl =…
Ole Albers
- 8,715
- 10
- 73
- 166
1
vote
2 answers
C# and ExcelLibrary How to Right Align cells
Does anybody know how to make it so that the content passed to the sheet will right align?
Anthony Abouhassan
- 55
- 1
- 2
- 10
1
vote
1 answer
ActiveXObject - Excel.Application does not release resources
I have developed this script where i write on an xls worksheet.
var excelFile = "C:\\TestActiveX\\Test.xls";
function readExcelFileAndUpdateView()
{
var w =new ActiveXObject("Excel.Application");
w.Workbooks.Open(excelFile);
var…
MaVRoSCy
- 17,747
- 15
- 82
- 125
1
vote
1 answer
How to get excell range name for HSSFCell apache POI API?
As title, I have a little trouble here.
I can get font from cell
HSSFFont font =
cell.getRow().getSheet().getWorkbook().
getFontAt(cell.getCellStyle().getFontIndex());
But now I need to get range name of it. Actually I need something to…
user1487380
- 362
- 2
- 9
- 26
1
vote
1 answer
ExcelLibrary Creating Too Many Worksheets
I am trying to write output to an Excel workbook using ExcelLibrary. I want this workbook to contain only one sheet but I can't find any way to either create a workbook with only one sheet or remove the extra sheets after creation. All of the…
Kevin
- 1,252
- 6
- 32
- 50
0
votes
3 answers
Converting this excel to datatable
I was earlier successful at converting Excel to datatable, but now, I have weirdly formatted table, following picture will show excel table, and table that I want to achieve.
var workbook = Workbook.Load("file.xls");
var worksheet =…
el ninho
- 4,183
- 15
- 56
- 77
0
votes
1 answer
Using ratios n Excell without reducing
Is it possible to convert A and B to ratio in excel, but not reduce it? It is for a employee to kids ratio in a daycare. 12 kids and 3 kids would be entered 12 in A and 3 in B to show 12:3. I just don't want it reduced to 4:1, Thanks!
Chad
- 1
0
votes
1 answer
How to fix vba code when it seems to not be reading my conditions?
The vba code seems to not be reading my conditions
I tried ="condition" and now with like and none of them seem to work
This is my code. The code is running with no issues but nothing is getting copied where it should (cells &j)
please help help…
user11418211
0
votes
0 answers
method activate of object _worksheet failed
I want to display a specific sheet when I open the Excel file, but I am facing an error, please guide me to fix this error.
Private Sub Workbook_Open()
Worksheets("rahnama").Activate
End Sub
Morteza Khavari
- 17
- 5
0
votes
0 answers
how to hide and show button on excel ribbon using VBA
Hii guys I am working a excel addin project which add custom ribbon using the ribbon xml structure defined by microsoft. I have 2 button on this ribbon login and logout .Now when the excel load I want to show login button only and when user login…
vibhor Gupta
- 103
- 11
0
votes
1 answer
How to export date column to excel in correct format via ExcelLibrary
I am exporting multiple DataTables to an Excel-file using ExcelLiabrary. The problem is that date column in all datatables, are being exported as number. DataTables are filled with data retrieved from Sql Server where the column type is date.…
Khalil
- 187
- 2
- 10
0
votes
2 answers
C# Excel from textbox to excel cell
I've a little problem about to copy and paste from textbox to excel cells. Basicly, When I get data from website to textbox, I can not put this values into excel cells regularly.
My data:
xxxxxxx-qqq-1111-13661 3********************* 01/02/2020…
mcakir
- 1
- 3
0
votes
1 answer
Combine several xlsx files into one single xlsx
I want to combine several xlsx files into one. However this xlsx files have different number of lines and they have highlight cells.
When I combine them into one, they appear to be next, without a row beteween the two dataframes, and they also lost…
Sofia
- 365
- 3
- 17
0
votes
1 answer
How to read Data from Google spread sheet using Robot Framework
I want to read data using Robot Framework from Google spread sheet.
say for example the spreadsheet location is :- https://www.swiggy.com/pop/listing
Can anyone guide me what RF steps are to be written to read the sheet data and store as a list in…
TG3017
- 33
- 2
- 10