Stack Overflow
Stack Overflow

Questions tagged [spreadsheetlight]

SpreadsheetLight is an open source Open XML spreadsheet library for .NET Framework written in C#, and is released under the MIT License.

SpreadsheetLight is an open source Open XML spreadsheet library for .NET Framework written in C#, and is released under the MIT License.

You can create new Open XML spreadsheets, or work with existing Open XML spreadsheets that are compatible with Microsoft Excel 2007/2010/2013 and LibreOffice Calc.

Links

Website

Tutorials

62 questions
0
votes
0 answers

Save Excel in a Specific map in Automatically approach

Is it possible to save a excel file in a specific folder without doing it manually?. I would like it to do it automatically.
HelloWorld1
  • 13,688
  • 28
  • 82
  • 145
0
votes
1 answer

Merge two SLDocuments to one SLDocument

I'm using SpreadsheetLight to create 2 seperate spreadsheets. One of them is with a chart but both are having only one worksheet. I'm trying to merge these two sheets into one spreadsheet with two worksheets. Each of the seperate sheets should be…
nitsuj1001
  • 51
  • 1
  • 1
  • 10
0
votes
1 answer

Get Names of all Columns in Excel sheet in SpreadSheetLight

I'm trying to populate a combobox with the names of the columns in a spreadsheet. I'm using the spreadsheetlight library. I can set the cell value using the following code where A refers to column name and 1 refers to row name. (Am I right?) But how…
techno
  • 6,100
  • 16
  • 86
  • 192
0
votes
2 answers

SpreadsheetLight c#

Does spreadsheetLight has any functionality for creating the excel sheet in Right-to-Left Direction. That is, A column should appear at the right on the excel sheet.
Hershika Sharma
  • 105
  • 1
  • 14
0
votes
1 answer

C# SpreadSheetsLight axis

i have a spreadsheet with table generated with SpreadsheetLight library, and chart from this table also generated with SpreadsheetLight. When i open generated result in excel and select chart, i can change rows for cols with button in excel (i don't…
m150
  • 173
  • 6
0
votes
1 answer

Proper way to detect #N/A in .XLSX with Spreadsheet Light

I have an Excel file (.xlsx), that I open in C# via Spreadsheet Light. Some Cells can have the value #N/A (or whichever representation your language version of Excel uses) as a result of an SVERWEIS (in German, I think it is VLOOKUP in…
MilConDoin
  • 734
  • 6
  • 24
0
votes
1 answer

How can I configure the print area and other printing properties of a sheet using Spreadsheet Light?

Using Excel Interop, I can configure a sheet for printing with code like this: _xlSheetPlatypus.PageSetup.PrintArea = "A1:" + GetExcelTextColumnName( _xlSheetPlatypus.UsedRange.Columns.Count) + …
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

How can I insert a picture into an Excel spreadsheet with Spreadsheet Light from a link rather than an image file?

It's easy to add a picture to a sheet with Spreadsheet Light like this: SLPicture logoPic = new SLPicture(@"C:\Platypus\DuckbillsUnlimited.png"); logoPic.SetPosition(0, 13); sl.InsertPicture(logoPic); ...but I want to use an image at an URL, not…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

How can I set the row height for a defined name (range) in Spreadsheet Light?

I am trying to convert Excel Interop code to Spreadsheet Light. The legacy Interop code I want to emulate is: var columnHeaderRowRange = _xlSheetFillRateByDistributorByCustomer.Range[ _xlSheetFillRateByDistributorByCustomer.Cells[1, 1], …
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

How can I add an earlier version of open XML to my C# project?

I am working on an application in C# with visual studio that manipulates xlsx spread sheets. Everything is working fine with open XML v2.5 and spreadsheet light, however the save function throws this error: Could not load type…
user3538411
  • 338
  • 4
  • 15
0
votes
4 answers

How to get format type of cell using c# in spreadsheetlight

I am using spreadsheetlight library to read Excel sheet(.xslx) values using c#. I can read the cell value using following code for (int col = stats.StartColumnIndex; col <= stats.EndColumnIndex; col++) { var value=…
Ranadheer Reddy
  • 4,202
  • 12
  • 55
  • 77
-1
votes
1 answer

C# Few issues regarding SpreadsheetLight usage

1) i am using SpreadsheetLight library and i like to know how could i set row's color red or yellow ? 2) also tell me how could i set color range wise say Range["A1:Z1"] ? 3) how to apply format cell range wise…
T_Zacks
  • 101
  • 2
  • 17
-1
votes
1 answer

Why would there be no data in the visualiser when there is valid data in the DataTable?

I'm trying to build a wrapper for SpreadsheetLight that returns a DataSet from any .xlsx document passed through it. However, I seem to be having a problem with DataRows not being added to a temporary DataTable. Here's part of the code that parses a…
Dezzamondo
  • 2,169
  • 2
  • 20
  • 33
-1
votes
3 answers

A variable has a value but throws an object reference not set to an instance of an object

I have a function that loops a DataTable and saves it as an Excel File using SpreadSheetLight for C# noticing that looping through the DataTable and saving its Excel File output takes time depending on how many cells and rows and columns a DataGrid…
TheQuestioner
  • 702
  • 10
  • 28
-1
votes
1 answer

convert DataGridView Contents to Excel using SpreadSheetLight in C#

so i'm trying to export the contents in a DataGridView to an Excel File. And for me to do this, i am using SpreadSheetLight for C#. But as far as reading the Sample Codes and Tutorials go, they're only demonstrating manual Excel content…
TheQuestioner
  • 702
  • 10
  • 28
1 2 3
4
5