Stack Overflow
Stack Overflow

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

How to sort Pivot Table in Aspose by row and column field values?

Please find the below image demonstrating what exactly I want to do. I have tried to do so in the below code, but it does not produce correct/readable Excel file. Alternatively, if I use the commented code, it produces the correct Excel file but…
Hitesh Dholaria
  • 157
  • 3
  • 13
0
votes
1 answer

Issue related to Reading Excel using Apache POI in java

I am trying to create an excel file of 2007. Scenario for Creation of Excel from other file. Input file :- InputFile.xlsx with One Sheet Calculation File :- Model.xlsx with four sheets Description for Calculation file :- 1) First Sheet is…
Sush
  • 307
  • 3
  • 14
0
votes
1 answer

How to delete Range in Aspose(using C#)

I am trying to remove the range through aspose but no luck. Actually i have created a range in excel but while exporting the excel when there is no data to insert into the excel and when we select the range it always select the empty rows. So i want…
ankit paul
  • 81
  • 1
  • 15
0
votes
1 answer

Class not found .jar file is not loaded in Python

I am unable to load .jar file for my python code, Here is my code for default.py from quickstart import HelloWorld import jpype import os.path path…
Muhammad Usama Saeed
  • 624
  • 1
  • 5
  • 13
0
votes
1 answer

Exception in importing data from excel to db

public List ImportProjectsFromExcel(string path) { LoadOptions loadOptionForXlsx = new LoadOptions(LoadFormat.Xlsx); Workbook workbook = new Workbook(path, loadOptionForXlsx); char column = 'A'; …
Asha B.
  • 83
  • 12
0
votes
1 answer

Aspose:Change to GetFormatConditions() in Aspose 8.x

FormatConditionCollection collection = localCell.GetFormatConditions(); ...... Int32 conditionIndexN = clN.AddCondition(FormatConditionType.Expression, OperatorType.None, collection[i].Formula1, collection[i].Formula2); i have code using…
NSN
  • 740
  • 3
  • 9
  • 26
0
votes
1 answer

Auto Sum Column in Aspose.Cells

I am new to Aspose.Cells and I am facing an issue with how to use auto sum on a Column in Aspose.Cells.It will be really helpful, if any one can help me. Thanks.
Anuja
  • 1
  • 1
0
votes
1 answer

Dynamic format in aspose.cells generated excel

Is it possible to create a conditional format or something like that where the format is depending on the value of the cell? For example when there is "#000000" as cell value, the background color of the cell should be black. It is possible to have…
Dominik Kirschenhofer
  • 1,205
  • 1
  • 13
  • 27
0
votes
1 answer

Create pdf file using Aspose with good performance

I have web application & I am using Aspose to create pdf using Excel template file with around 15 columns. I am able to create pdf successfully but it is taking too much time for this. eg. for 28K records it is taking 2.5 to 3 min. Using this…
SO19
  • 105
  • 9
0
votes
1 answer

Aspose Cell Java - Splitting Cell Horizontally

How do i fit values in those horizontally splitted cells ? I am cloning each row dynamically. The values being populated currently is a merge field as i was using this approach but i couldn't make the report dynamic with it. Any help would be…
Aman Adhikari
  • 3,240
  • 3
  • 22
  • 32
0
votes
1 answer

Cell.Formula gives #name error until user selects formula

In my program I create an excel file with a formula containing a reference to a table (listobject). When opening the resulting excel file the formula shows the #NAME? error until the user selects the formula and exits it again. First I…
Boris Callens
  • 90,659
  • 85
  • 207
  • 305
0
votes
2 answers

Worksheet ranges doesn't contain newly created range

In my current project I want to find the ranges of a worksheet, but the lookupWorksheet.Cells.Ranges property contains no elements while Workbook.Worksheets.GetNamedRanges() does. My initial code was var sheetRanges =…
Boris Callens
  • 90,659
  • 85
  • 207
  • 305
0
votes
1 answer

"Failure to find com.aspose:aspose-email:jar:5.3.0.0" when running GroupDocs sample "Java Viewer - Sample Dropwizard"

I'm trying to run this sample "GroupDocs Java Viewer - Sample Dropwizard" download it from here it need these jar files: aspose-email-5.3.0.0.jar aspose-imaging-2.9.0.jar aspose-words-15.6.0.jar aspose-slides-15.5.1.jar I can not find…
E.day
  • 97
  • 2
  • 14
0
votes
1 answer

Aspose subscription error

In one of our application we use Aspose.Cells (v 5.1.4.0) for excel generation. last day I was checking something and installed the latest version of the Aspose.Cells and now I am getting below error - The subscription included in this license…
Rohit
  • 1,520
  • 2
  • 17
  • 36
0
votes
1 answer

column.applyStyle(style, styleFlag); not give proper result?

I am trying format a column data for number. Below are code working for Single cell. //Instantiating a Workbook object Workbook workbook = new Workbook(); //Accessing the added worksheet in the Excel file int sheetIndex =…
Janny
  • 681
  • 1
  • 8
  • 33
1 2 3
…
20 21