Questions tagged [aspose-cells]

Aspose.Cells is a spreadsheet component that allows .NET and Java developers to embed the ability to read, write, convert and manipulate Excel spreadsheets into their own applications without needing to rely on Microsoft Excel.

Aspose.Cells is a spreadsheet component that allows .NET and Java developers to embed the ability to read, write, convert and manipulate Excel spreadsheets into their own applications without needing to rely on Microsoft Excel.

304 questions
0
votes
1 answer

ASPOSE.CELLS : Why does a simple Workbook.Save throw a Null Reference Exception?

I'm using Aspose.Cells DLLs Version 7.0.0.0 on 64-Bit Windows 7 with .NET 4.0 on my machine. It does work on my friends machine, which is running 32-bit windows 7 also with .NET 4.0 - I suspect difference in windows version (x64/x86) could be a…
Zasz
  • 12,330
  • 9
  • 43
  • 63
0
votes
1 answer

Dynamically set column in sum formula using aspose.cells

I am use aspose excel export. I am setting formulla in .net. I want sum of two cells value in third cell. like excelbook.Worksheets[0].Cells["A2"].R1C1Formula = "=SUM(R1C1,R1C2)"; but i want to set the column dynamically. like in above formulla…
KAPIL BHATIA
  • 99
  • 1
  • 6
  • 14
0
votes
0 answers

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() from asposecells.api import Workbook timestamp =…
macikeci
  • 3
  • 2
0
votes
2 answers

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 able to open the file by repairing or removing…
Asif Iqbal
  • 531
  • 8
  • 28
0
votes
1 answer

how to export an image into an Excel file without Excel installed (using ASP.Net/VB.Net)

I need to export Chart(image) and grid (tabular) row data into excel file. I can not use automation because Office tools are not installed in my server. I've found a bunch of free/proprietary tools like: NPOI MyXLS ExcelWriter…
user984694
0
votes
0 answers

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 not run successfully. │ exit code: 1 ╰─> [7…
Siddhi
  • 1
0
votes
1 answer

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 names. if they don’t match, then I have to add said…
mhepner
  • 3
  • 3
0
votes
2 answers

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 =…
dishanm
  • 110
  • 1
  • 11
0
votes
0 answers

Is it possible to replace a file in the ASP.NET MVC pipeline

I have a macro enabled Excel spreadsheet (*.xlsm) that is being uploaded to an ASP.NET MVC controller. The controller method has validation in it that does not allow macro enabled excel spreadsheets. What I have done in the controller is to check…
Nathan Fisher
  • 7,961
  • 3
  • 47
  • 68
0
votes
1 answer

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 text I cannot click on the link. Below is the…
0
votes
0 answers

Convert a bunch of cells to an image in Java using aspose.cells

I want to convert a few cells (which have made to appear as a chart but are not a chart) to an image using Maven in Java. I have written the below code - public void celltoImage(String sheetname, int firstrow, int firstcol, int totalrow, int…
0
votes
0 answers

Autofit columns in a range of cells without affecting other columns

I am working on a project where I use the Aspose.Cells tool. I am inserting information from C#, this information is generated as a table but in reality I do it by means of cells, for which I bring a height and width of columns and rows, so when I…
Isalu
  • 1
0
votes
0 answers

Unable to access Slicer Values using Asposecells but am on the slicer that has options

I am trying to use asposecells to update a number of pivot tables by updating a single slicer with connections to all pviots. This is an OLAP datasouce. The slicer in question has month start date as the values to select from. enter image…
0
votes
1 answer

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 values, or on a specific scope as you prefer. The VBA…
GVA32156
  • 3
  • 1
0
votes
1 answer

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 to do this. I've tried this but it autofits all…
Tom Kurian
  • 113
  • 13