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
1
vote
1 answer

How to add FieldFormula into Cell using aspose word in java

Does any way to add formula into table using aspose word java API. I writen a code to generate aggregate row but I search related for formula content control. I found API FieldFormula, this field API. Can we add field into Cell? private void…
bNd
  • 7,512
  • 7
  • 39
  • 72
1
vote
1 answer

aspose cells for java filter with contains option

I am working on the autofilter option in aspose cells for java . AutoFilter autoFilter = worksheet.getAutoFilter(); autoFilter.setRange("A1:D1"); autoFilter.filter(1, "Student"); This is working fine. But for the 3rd column I want to filter with…
Sowmya
  • 453
  • 1
  • 5
  • 18
1
vote
0 answers

Error opening 2 excel files using Aspose.Cells on Mono

I'm writing a small program using Mono and Aspose.Cells. I stack with the problem, that Aspose.Cell don't open 2 excel files in one project. Here is my code: protected string GetCellValue(string excelFileName, int row, int cell) { …
nast90210
  • 11
  • 1
1
vote
1 answer

How can I set aspose cells to take the locale for date format from OS?

I am creating an excel with Aspose. I would like that the date will be formatted according to the OS's Locale, meaning that if the excel will be open in US or Europe the dates will appear in a different format, like if you select the format with…
Shirly
  • 11
  • 3
1
vote
1 answer

Aspose Cells - Preserver the leading zeros in a CSV

I am using Aspose cells for a pretty simple report. The problem is that I have a few fields that have leading zeros. When opened in CSV, I do not see the leading zeros. If I look at the text, I can see the zeros Any ideas how to keep the leading…
H20rider
  • 2,162
  • 5
  • 29
  • 47
1
vote
2 answers

Add validation to entire column

In my current project I need to create an excel file with a list validation on an entire column. Googling turned up with the following two results: http://www.aspose.com/docs/display/cellsnet/Working+with+Validations+in+Columns This refers to…
Boris Callens
  • 90,659
  • 85
  • 207
  • 305
1
vote
1 answer

How to format number cell in excel by Aspose?

I am using Aspose for creating excel. I am getting few difficulties. 1st issue Cells.importResultSet in this how to insert customDateFormatString 2nd issue Cells.importResultSet in this how to insert customNumberFormatString Please check the…
Janny
  • 681
  • 1
  • 8
  • 33
1
vote
1 answer

How to insert a list of values in a column in excel sheet using aspose library in android?

I am using aspose.cell library in my android application to create excel sheets as an output in sdcard. Here is my code: void insertData() throws Exception { //Get the SD card path String sdPath =…
Rubanraj Ravichandran
  • 1,213
  • 2
  • 17
  • 26
1
vote
2 answers

How to read one row at a time from excel file using aspose in java

I have an excel file with 1000's of rows and I want read each row at a time in Java using aspose API's. I want to convert each row into a String array. Can anyone help me with this? Worksheet worksheet = workbook.getWorksheets().get(0); Cells cells…
user3566201
  • 47
  • 1
  • 7
1
vote
1 answer

Formatting leading zeros with Aspose

I'm losing leading zeros on zipcodes when generating pdfs via Aspose. I've come to the conclusion that Excel is formatting the cells with zipcodes as a number, which strips any leading zeros. The Aspose documentation explains how to format a cell…
noclist
  • 1,659
  • 2
  • 25
  • 66
1
vote
1 answer

Aspose cell: How to add a new column with name (header name) to existing Listobject?

I have a situation where I need to add a new column to the existing ListObject and also update the new column header value. Can anyone help on this? I am using aspose 7.4.2.0. Thanks in advance.
Nikhil
  • 299
  • 3
  • 6
  • 17
1
vote
2 answers

Aspose Cells Java - Insert Row to Excel Table

I'm new to aspose cells. I've a template excel file that has a simple Data Table (with a header row and one empty row) and a bar chart (with the data table configured as source). With aspose cells version 8.1.1. i'm trying to read the excel file,…
Kathir
  • 27
  • 7
1
vote
2 answers

Aspose.Cells in Android Studio : OutOfMemoryError

I have referenced Aspose.Cells jar file in my Android Studio project, but I get the following error when I compile: Error:Execution failed for task ':kpi:preDexDebug'. com.android.ide.common.internal.LoggedErrorException: Failed to run command: …
jcmag
  • 35
  • 2
1
vote
1 answer

aspose.cell csv reading with single quote as text qualifier and comma as column delimiter

I am using aspose.cell to read my csv file with "," as column delimiter & single quote (') as text qualifier & newline as row delimiter. Looks like below one: ex: '1'.'2','3','4' '5','6','7','8' while reading from aspose.cell, the…
nRk
  • 1,251
  • 7
  • 24
  • 50
1
vote
1 answer

Aspose cells to read table header row

How can i retrive excel table header row. I able to retrive all rows except table header row. Code private static void printTableContent(final ListObject table) { System.out.println(table.getShowHeaderRow()); Range range =…
Ashish Aggarwal
  • 3,018
  • 2
  • 23
  • 46
1 2 3
…
20 21