309 questions
0
votes
0
answers
23
views
Aspose.Cells (.NET) (25.5.0): Error Logging
I was wondering is there a way to configure error logging for Aspose.Cells (.NET). The version I am using is, 25.5.0.
I am facing one issue with an excel workbook that has more than 10 excel sheets ...
- 1
0
votes
2
answers
81
views
Change one word in specific row in Excel file using Python
I found out how to change text in Excel file with Aspose.Cells for Python through Java:
import jpype
import asposecells
jpype.startJVM()
from asposecells.api import *
import os
os.chdir(r"c:\...
0
votes
1
answer
56
views
Aspose.Cells Pivot PrintArea
When shifting from Aspose Cells v 25.3.0 to 25.4.0, the PrintArea behavior changed.
Background: given an excel spreadsheet like this:
Year
Product
Gross
Net
-
-
-
2001
Apples
100
30
Row Labels
Sum of ...
- 2,307
1
vote
0
answers
45
views
how to make Aspose cell cpp chart as a Line chart
Below is aspose cell cpp sample for line chart.
but it shows only blue triangle filled with blue
how to make this showing line chart?
Aspose::Cells::Startup();
License lic;
lic.SetLicense(u"...
- 11
0
votes
1
answer
75
views
How to group row_fields using aspose-cells-python 24.10.0 into one cell
I have 3 non-date columns in the input Excel file, and I want 3 PivotFieldType.ROW fields that can be explicitly grouped so that there is a select field drop-down option on the cell. This code is ...
0
votes
1
answer
63
views
Embeded excel file in word document doesnt keep file name
I am using Aspose Words Version=16.7.0.0 and i am embedding excel file in word document using the code below but i cannot preserve the file name of excel file when i open it.
The steps are:
Creating ...
0
votes
1
answer
391
views
How to get the html formatting from Excel Sheet Cells in Java
We are trying to get the html formatting from excel cell(basically the cell text in html format) including bullet points, italics, new lines, highlights, hyperlinks etc.
We are using Apache POI but it ...
- 563
0
votes
1
answer
111
views
Need formatting rule for Excel Aspose for certian condition
I have a excel in which i have some columns which adds upto a end column total expences and that column value(expences total cell) decide which is the best row and according to it we have three colors ...
- 319
0
votes
1
answer
107
views
show the excel value as Red if the cellvalue is negative with comma for Polish and Czech Republic culture
I am working on excel report generation using Aspose, my users are across various countries and they should see the report in their culture.
I am using aspose.net to generate the excel report, for ...
- 699
0
votes
1
answer
262
views
Aspose.Cells - get the rangename for a cell
I'm using aspose.cells in a .NET application. Let's say I have an excel workbook with three sheets named Sheet1, Sheet2, Sheet3. In Sheet1, cell A1 has been named "Apple" with global scope....
- 339
0
votes
0
answers
353
views
failed to execute script with Jpype
I'm working sap automatization(I use anaconda) and at the end of my code I use Jpype and aspose to make my excel read only password protected file.
import jpype
import asposecells
jpype.startJVM()
...
- 3
-1
votes
1
answer
995
views
Download Excel file from a MemoryStream in C#
I'm having a problem downloading a Excel file in browser using React.js.
Here is the situation:
I have written an API which will take an Excel file as input , then after modifying it using Aspose ...
0
votes
2
answers
260
views
Cell Validation fails while dynamically binding the dropdown list to a cell using Aspose C#
I have created an extension method to bind 2 different dropdownlist to specific cells using aspose.
First dropdown is working fine but while binding the second dropdown, it throws error as
Excel was ...
- 543
-1
votes
1
answer
430
views
Read too large CSV with with c#
I have to extract specifict information from a too big CSV file with C#, the file is 233 MB in size, it has 1000008 rows and 28 columns and insert tha information in a datatable.
actually i tried with ...
0
votes
0
answers
113
views
python setup.py egg_info did not run successfully. While installing aspose-total-java
Collecting aspose-total-java
Using cached aspose-total-java-22.6.0.tar.gz (3.4 kB)
Preparing metadata (setup.py) ... error
error: subprocess-exited-with-error
× python setup.py egg_info did ...
- 1
0
votes
1
answer
259
views
How to Compare Aspose Cells to Files in NetWork Folder
I am new here and looking for some help, as I’ve been stuck on an issue…
I’ve been tasked with creating an app that requires me to compare a range of aspose cells in ** c#** to an iteration of file ...
- 3
0
votes
2
answers
101
views
how to add customized fields before saving the data to json
I have a simple python program which converts excel to json .
import jpype
import asposecells
jpype.startJVM()
from asposecells.api import Workbook
workbook = Workbook("sample.xlsx&...
- 120
0
votes
1
answer
571
views
Adding Hyperlink on Cell with Rich Text
I have a variable with rich text and am trying to write the data in an Excel cell using Aspose.Cells. The text formatting is coming fine but the Hyperlink is not getting rendered, it's coming as plain ...
- 197
0
votes
1
answer
231
views
Select specific range/scope of a pivot table to apply format on (Aspose.Cells for Java)
Is there an equivalent of this VBA function PivotTable.PivotSelect in Aspose.Cells product ?
I am looking for a way to create a border on a whole selection of cells containing specific data field ...
- 3
0
votes
1
answer
132
views
Autosize only Merged Cells using Aspose
I saw that there was a way to autofit rows in the worksheet. But I only want to autofit the rows that have only merged cells in it. And keep all of the other rows the same. Not sure if there is a way ...
- 115
0
votes
1
answer
618
views
ImportError: Failed to import ‘com.aspose’ after building exe in python 3.11.1
I use Python’s AsposeCells to generate PNG images from excel files. First off, it works properly with my Python code. But I encountered this issue when I tried to turn my script into an exe file with ...
0
votes
1
answer
606
views
No matching overloads found for *static* com.aspose.cells
I have this code in python running jpype and asposeCells libraries, the purpose of this code is to convert numbers in text format (cells with green arrow) into actual numeric value
import jpype
import ...
- 3
0
votes
1
answer
733
views
Aspose excel autofitcolumn but for a certain width
I want to fit column according to header width not the properties width.Ie Header size should be the column width )
i am using sheet.AutoFitColumns(); which fits according to the max length of cell.
...
- 319
0
votes
0
answers
220
views
Aspose Java API : How to fetch Row from excel workbook which has maximum data in it
I want to get a row from XLSX workbook which has maximum data in it. I have the "com.aspose.cells.Cells" object of worksheet.
workbook = new Workbook(sourceFilePath);
com.aspose.cells....
- 11
0
votes
1
answer
470
views
Set excel file headers to Pascal Case in Aspose .net 6
I've following code that maps given json array of objects to excel file. But it outputs the file with headers in lower case. I want the headers to be in Pascal Case. Can someone help or lead me to ...
- 65
0
votes
1
answer
975
views
The signature is invalid when applying new Aspose.Words.lic and Aspose.Cells.lic
We have renewed the "Aspose.Cells.lic" and "Aspose.Words.lic"
the steps that we did:
we have downloaded the files.
we replaced the new files with the old ones, but we noticed that ...
- 15
0
votes
0
answers
1k
views
How to start JVM via JPype on Linux?
I use Aspose.Cells for Python via Java on Linux. I try to start the JVM, but it gives me an error because it looks like it can't find and enable it.
File "/home/user/.local/lib/python3.10/site-...
- 61
0
votes
0
answers
318
views
Can't open .xlsx file from aspose cells if it wasn't created using aspose cells
So I'm working on an app for android and I've gotten it to work as long as it's been created using aspose cells. Here is my code:
class Home: Fragment(R.layout.fragment_home) {
override fun ...
user17792511
0
votes
1
answer
471
views
How add Water Mark to complete sheet of Excel using Aspose library in C#
I'm using Aspose library to generate Excel report in this I'm facing issue to generate watermark to complete excel.I can able to generate watermark for only some cells but here I need to do for ...
- 3
0
votes
1
answer
1k
views
NoClassDefFoundError, but the code works and the class exists
I have a Maven project and I'm using Aspose cells to manipulate an xlsx file. Aspose is configured through the POM
<?xml version="1.0" encoding="UTF-8" standalone="no"?...
- 11
0
votes
2
answers
2k
views
Aspose dependency not working with gradle
I am trying to add Aspose cells dependency in gradle but I am not able to make it work .
Attaching the gradle file and the error in terminal for the same.
- 49
0
votes
1
answer
966
views
Is there a way to format an Aspose.Cells generated excel sheet without calling Workbook.Save()?
My customer has a use case for exporting search results to a spreadsheet. I would like to return a formatted spreadsheet to them, but the only way I can get the formatting changes to "stick" ...
0
votes
1
answer
723
views
Using how to import data set into excel and return as memorystream? receiving an error inside workbook.Save(stream)
public static MemoryStream GenerateExcelReport(DataSet objDS)
{
// Instantiating a Workbook object
Workbook workbook = new Workbook();
// Obtaining the ...
- 3
0
votes
0
answers
347
views
java poi export Excel use Header, but show garbled characters with Chinese word
export excel with Header(return XSSFOddHeader),transform to PDF,it show me the mess code when i input Chinese.
I tried to transform the stirng encode and set the response header and contenttype，but it ...
0
votes
0
answers
1k
views
Is there a way to combine two Excel files together using Javascript?
I am using ExcelJS npm oackage to generate my excel files in NestJS , it works fine for most part but I am unable to find a way to merge wroksheets from various workbooks in single new workbook ALONG ...
- 49
0
votes
1
answer
1k
views
I am trying to work with excel files with aspose cell so that I can encrypted them but its not working because of Java
import jpype
import asposecells
jpype.startJVM()
from asposecells.api import *
for this code, I get the following error
JVMNotFoundException: No JVM shared library file (jvm.dll) found. Try setting ...
- 11
0
votes
0
answers
513
views
Convert csv file to xlsx in android java [android 6]
I am creating a csv file by taking data from SQLite table. I want to convert the csv file to xlsx format for it to be shared by bluetooth. I am limited to android 6.
I have tried:
Apache POI (Min SDK ...
0
votes
1
answer
522
views
How to put value into span cell using aspose.cell?
I am using Aspose. Cell for .net to write some data into Excel. I have a quick question:
what are the best practices to get and write a value into the below cell?
this kind of cell may be across ...
- 425
0
votes
1
answer
450
views
How to put choice value using aspose.cell?
I am using Aspose. Cell for .net to write some data into Excel. I have a quick question:
how to insert such kind of value?
I find that there is a method "cell.putvalue(string)" , is it ...
- 425
0
votes
1
answer
767
views
Error trying to install latest nuget pkg Aspose.Cells
Trying to install the latest Aspose.Cells package in VS 2019. Had a buddy try the same thing, same error. Have a license. What am I missing?
Severity Code Description Project File Line ...
- 7,032
1
vote
1
answer
1k
views
How to use LightCells Api to read and write large excel files in Aspose.Cells
I want to make use of the LightCells API within Aspose.Cells to help optimize my read and write processes while also reducing the memory utilization while processing the excel file.
I have queries ...
0
votes
1
answer
809
views
C# Aspose Word Table : How to add Overline style to a Cell text
I'm new to Aspose.Words for .Net specifically Tables, and working on recreating some documents for a customer , and i want to create a table with severel rows and columns dynamically,
my question is ...
0
votes
0
answers
937
views
Date format Issue while reading with Aspose
I want to read dates from .xlsx file , I am using Aspose to read the date value from the column,
But the output date value i got was in a different date format, Following are the dates needed
in ...
1
vote
1
answer
581
views
With Aspose Cells, how to copy a Cell formula to another cell and update its references in .Net Core without its formating
I'm using Aspose Cells with .net Core.
I would like to copy a cell formula to another cell and update the cells references in the formula with its new "location".
If I use the cell.copy it's ...
- 1,749
0
votes
1
answer
1k
views
Write huge rows in Excel file (.xls format older version) in chunks without loading complete file in memory
I'm working on a feature to export data into Excel file (.xls (Older version) format support).
I have to append chunks into .xls file, without loading file into memory. The file should be in .xls ...
1
vote
2
answers
871
views
Aspose Worksheet not parsing decimal numbers correctly on German server; ignoring period delimiter (123.45 -> 12345)
I have an import task that parses a huge .dat file as an Aspose Workbook.
This was the original code:
public static List<QueryResult> GetAsposeExcelDocumentWithSheetIndex(string filename, ...
- 4,933
0
votes
1
answer
551
views
Aspose cells - Bad results when saving html workbook to Xlsx on Linux machine
I’m using Aspose cells version 19.10.
I have an html file with a table which I would like to save to an Xlsx file.
HtmlLoadOptions loadOptions = new HtmlLoadOptions();
loadOptions....
1
vote
0
answers
179
views
Get MDX generated by Excel cube formulas
I have a requirement to open excel workbooks in a web environment, rendered using a third part excel emulator (Aspose cells). This works fine until I hit workbooks which use cube formulas (CUBEMEMBER, ...
- 1,559
0
votes
1
answer
3k
views
ModuleNotFoundError: No module named 'com.aspose'
I installed aspose-cells on databricks. When we run the code we get: ModuleNotFoundError on apsosecells.api
import the required libraries:
import jpype
jpype.startJVM()
import asposecells
from ...
1
vote
1
answer
275
views
How to Hide Prefix Apostrophe using Aspose Cells
I have a text file that im converting to Excel using Aspose Cells for .NET.
My data contains numeric values that are being converted to scientific notation, so to counteract that I added an apostrophe ...
