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
0 answers

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, CUBEVALUE etc), The Aspose product (and the…
Programnik
  • 1,449
  • 1
  • 9
  • 13
1
vote
1 answer

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 to the beginning of all the the text in the…
Thegan Govender
  • 35
  • 6
1
vote
0 answers

Not able to apply mso-number-format in HTML for HTML string to Excel conversion using Aspose Cells

I am trying to convert Html string to Excel using Aspose Cells. I am trying to convert negative number to number with parenthesis and comma and the number to be aligned in such a way that the decimal point comes in single line as shown in the below…
Newinjava
  • 972
  • 1
  • 12
  • 19
1
vote
0 answers

Is there a way to set the datatype of Aspose cells directly from the c# code?

I need to specify the datatype of the Aspose cells directly from the C# code. When I try to set a value to ‘cell.Type’, I get an error that, ‘Property or indexer ‘Cell.Type’ cannot be assigned to – its is read only’. Is there any other way to do…
gunner4evr
  • 79
  • 7
1
vote
2 answers

ASPOSE: How to correctly get Total Rows in Worksheet

Currently using Aspose for .NET in a C# WebService. I am currently having issues getting the correct Total Rows using worksheet.Cells.Rows.Count It is showing that I have around 230 rows but inside the file, I only have 14 rows. I am guessing…
dantz
  • 37
  • 1
  • 9
1
vote
1 answer

Aspose.Cells NuGet 18.3 Worksheet object seems to to have different API for .Net Core

Until now we used the Aspose.Cells dll (.Net c#) version 17.1, now me changed to Aspose.Cells Nuget package 18.3 and converted to .net core and It seems that the Worksheet class doesn't support many features. e.g. Looks like these ones don't exist…
Amir M
  • 508
  • 1
  • 8
  • 28
1
vote
1 answer

Special character encoding in aspose words

I'm using aspose cells, word to treat a csv file and copy it into a Word template and finally convert it to Pdf. On dev env it works like a charm, how ever in production I have some letter like ö which does not appear only in production env. I…
Khalil M
  • 1,788
  • 2
  • 22
  • 36
1
vote
1 answer

Weird behavior with local functions and shared variables

I'm generating an Excel file for a budget and there is a weird behavior with the local functions. The problem seems to be with the shared variable rowIndex. For some reason, the total formula overwrites the content of the first cell of each section…
Martin D.
  • 1,950
  • 3
  • 23
  • 33
1
vote
1 answer

Aspose.Cells - The File is Corrupted

When I try to open a text file to a xlsx format from Aspose.Cells with this code: Excel.Workbook workbook = new Excel.Workbook(filePath, new Excel.TxtLoadOptions(Excel.LoadFormat.Xlsx) { SeparatorString = " " }); it crashes with the exception…
Zaehos
  • 175
  • 2
  • 13
1
vote
2 answers

Aspose.Cell error in .Net Standard 2.0 Library

Could not load file or assembly ‘Aspose.Cells, Version=19.7.0.0, Culture=neutral, PublicKeyToken=716fcc553a201e56’ or one of its dependencies. The located assembly’s manifest definition does not match the assembly reference. (Exception from HRESULT:…
Sachin
  • 459
  • 1
  • 7
  • 22
1
vote
2 answers

Aspose.Cells.CellsException - "You are using an evaluation copy and have opened files exceeding limitation"

I have created a function that returns a datatable from a workbook. public async Task GetDataTableFromTabRowColumn(string sheetName, int startRow, int endRow, int startCol, int endCol) { var task = new Task(() => { …
Adrita Sharma
  • 21,581
  • 10
  • 69
  • 79
1
vote
1 answer

Generate Image from Excel sheet containg more than one sheet and bulk amount of data?

I am generating image of excel sheet using aspose.cells and it is working fine but when I try to generate excel file containing 4 sheets and bulk amount of data in them it produces an error OutOfHeapMemory And if I put condition than it reads…
Tanisha Agarwal
  • 115
  • 16
1
vote
1 answer

How to use Aspose.Cells in existing project in netBeans?

I want to convert excel sheet data to image and currently I was working with graphics 2D of awt but it is not giving me desired result. I have read that aspose.cells can be used for converting to image but when I try to implement it gives me error…
Tanisha Agarwal
  • 115
  • 16
1
vote
1 answer

Generating Excel File using .NET Aspose Cells and trying to download via browser

I am trying to dynamically generate an excel version of an HTML report using .NET Aspose Cells. The situation requires the generation of the Excel file and then the passing of the Excel file to the user's browser for download. I create a csv file…
Fendec
  • 367
  • 1
  • 5
  • 23
1
vote
2 answers

Aspose Cells ExportDataTable CellsException

I am trying to read an excel file of size 263 KB, it includes 3 columns and 6998 rows of data, the first column is alphanumeric id Site ID ex: 'D7302', and the other 2 columns are latitude and longitude of type decimal, try { …
Elias Ghali
  • 823
  • 1
  • 13
  • 29
1 2
3
…
20 21