Independent .NET class library which allows user to directly operate Excel document, format and style and insert content to Excel document without Microsoft Office.
Questions tagged [spire.xls]
34 questions
1
vote
0 answers
C# Spire.Xls Exception: The entry pivotCacheDefinition2.xml already exists in the zip
Presentation
I'm using C# and Spire.Xls to edit excel files and to interrogate a SQL Database.
Each time I run the program (WPF) I want to open exisiting Excel file to delete and create sheets and pivot tables based on SQL database…
blondix210
- 11
- 2
1
vote
1 answer
How to remove Spire.XLS signature from pdf File?
I'm working on java, i have an excel file named "file.xlsx" that i want to convert to pdf using Spire.XLS , this is the code i wrote for that :
//Create a Workbook instance
workbook = new Workbook();
//Load an…
dEs12ZER
- 788
- 4
- 24
- 51
1
vote
1 answer
How to put a Spire.Xls.Collections.PicturesCollection into a string builder in c#?
So what I'm trying todo is get these pictures and put them into the string builder.
StringBuilder sb = new StringBuilder();
Spire.Xls.Workbook workbook = new Spire.Xls.Workbook();
workbook.LoadFromFile(Path.Combine(path,…
user16393971
1
vote
1 answer
How to save a ExcelPicture in c#?
So i have these ExcelPictures that i want to save to a Specfic path.
ExcelPicture picture = sheet.Pictures[minIndex];
Francisco Perez
- 29
- 3
1
vote
1 answer
Spire.xls - return a File from a stream for client download
Here is what I'm trying to accomplish.
I am creating an asp.net MVC application. My restrictions are that I cannot programmatically save anything to the file structure of the server, so I can't save it as a physical file on the host, and then grab…
Tim Jones
- 185
- 2
- 11
1
vote
1 answer
How to convert Spire.Xls workbook to DataTable for run to my excel cell's value replacement under a certain column
I want to build that on excel file cell's value replacement under a certain column app but I get an error
I searched but I could not find any solution
using Spire.Xls;
using System;
using System;
using System.Xml;
using System.Data;
using…
Cankat Saraç
- 13
- 6
1
vote
2 answers
How can I clone a workbook in Spire.XLS?
I have a Spire.Xls.Workbook object which I would like to clone. Since the class doesn't offer a Clone method I tried to create a new workbook and copy all existing worksheets over from the existing workbook. This is my code:
public void…
Bill Tür stands with Ukraine
- 3,425
- 30
- 38
- 48
1
vote
0 answers
Conditional formatting issue while converting .XLS to .XLSM using Spire.XLS
I am using Spire.XLS to convert XLS files to .XLSM files.
Spire.Xls.Workbook lobjDSTemplateWorkbook = new Spire.Xls.Workbook();
lobjDSTemplateWorkbook.DisableMacrosStart =…
Upendhar Singirikonda
- 179
- 14
1
vote
2 answers
Add new sheet to Excel workbook to store data when row limit > 1M
I am trying to store some data into an excel file using Spire.Xls.
When copying data from multiple files into the first sheet of another excel file, I want to create a new excel sheet when reaching the row = 1,048,575, and paste the data into this…
StackUseR
- 884
- 1
- 11
- 40
1
vote
1 answer
Get formula result from Excel cell using Spire.xls
I'm trying to read data in a xlsx file (in C# WPF with spire xls) but when the cell contains a formula I can only get the formula and I don't know how to get the result
I've tried this :
wb.LoadFromFile("...");
wb.CalculateAllValue();
…
Tib
- 31
- 2
- 8
0
votes
1 answer
spire.xls for Python produces AttributeError: 'NoneType' object has no attribute 'Workbook_Dispose'
I am trying to write a simple program in Python that saves an excel file to a pdf. I am using code I found with a google search. I ran
pip install Spire.XLS-for-Python
and
pip install plum-dispatch==2.1.1
which was successful .
This is the code…
alfa0000
- 1
- 3
0
votes
0 answers
Getting files stored in TextBox1 for conversion
Good day.
I am newbie in coding and need your help.
I am trying to create an app which will.
Browse all doc, XLS and ppt files through browse button and will show the file names in TextBox1.
When I will click Convert Button, it will grab files from…
0
votes
0 answers
Could not load type 'spr' from assembly Spire.XLS
I`m using the latest FreeSpire.Xls library with .net 7
When i touch this
Workbook workbook = new Workbook()
i have an error
Could not load type 'spr' from assembly 'Spire.XLS, Version=12.7.0.0, Culture=neutral, PublicKeyToken=663f351905198cb3'…
dasper
- 33
- 6
0
votes
1 answer
Spire.xls is deleting all macros
I have an xlsm file (Excel with macros).
I open it in C# with Spire.xls, make changes, save it.
Now all the VBA, modules, classes, and code behind the forms are gone.
Spire doesn't do anything with macros, but I had hoped that it would at least…
BWhite
- 713
- 1
- 7
- 24
0
votes
1 answer
c# - Using Spire to convert pdf into excel through byte[]data in Stream (need to draw into pdf)
Good day, I am developing a feature which download excel based on the pdf layout set using iText. A byte[] data is generated from the iText which in this form "����hp�" if I Console.WriteLine it in LineEncoding.UTF8.GetString.
I want to load the…
Koh Jia Sheng
- 1
- 2