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

Aspose.Cells for .NET is taking long time to read a Stream (on one machine only!)

In an MVC5 application with .NET 4.6.1 with IIS Express on Windows 7 and Visual Studio 2015 Update 3. I tried both Aspose.Cells v8.9.1 and 16.10.0 . Workbook excelWorkbook = new Workbook(uploadFile.InputStream); This line takes huge amount of time…
Adam
  • 3,872
  • 6
  • 36
  • 66
0
votes
2 answers

Excel cells coloring

I have this sheet in excel called Export and I want its header to be gray. Here is the code: protected void btnExcel_OnClick(object sender, EventArgs e) { var ex = new Aspose.Cells.Workbook(); ex.Worksheets.Clear(); …
Jess Wss
  • 39
  • 1
  • 1
  • 7
0
votes
1 answer

Aspose Workbook not created for excel template containing images

In my java application i am trying to create a Workbook from a template. Here is a code snippet to do that, InputStream inStream=new FileInputStream(file); Workbook workbook = new Workbook(inStream); When the template is blank or contains…
Prabin Upreti
  • 498
  • 5
  • 16
0
votes
1 answer

Excel created by C# .net, not able to convert to pdf properly

I have an excel file stored in database.I am trying to export this file into pdf by using Aspose.Cell. The pdf file which has been generated is not showing all the fields that exists in excel file. byte[] data =…
Vishwajeet
  • 1,575
  • 2
  • 19
  • 35
0
votes
1 answer

Aspose formula having a column index changing issue

I am using aspose 8.0.1.0 in a windows (C#) application. When I set the formula for a column as sheet1.Cells[3, 2].Formula = "='Supplies - Factor'!G757222"; the formula automatically changed to "='Supplies - Factor'!G36326" I have verified it…
Jithin Joy
  • 483
  • 4
  • 15
0
votes
1 answer

aspose cells workbook threw an exception of type 'System.FormatException'

the content of new.html is mentioned below:
aggy
  • 163
  • 1
  • 2
  • 14
0
votes
1 answer

How to include line breaks in HTML imported by Aspose Cells

I'm using a product called "Aspose Cells" which allows me to generate an Excel workbook from HTML. Recently, I wrote code to export a large table to Excel using Aspose Cells. I'm running into a problem where line breaks are stripped out of my…
Vivian River
  • 31,198
  • 62
  • 198
  • 313
0
votes
2 answers

Issue with APOSE.CELLS in Java

I am using ASPOSE.CELLS to sort an excel sheet but I am getting an exception when I am trying to save a workbook. What can the problem be? The code is also generating a corrupted excel workbook. Exception in thread "main"…
Avikaran Singh Bedi
  • 11
  • 3
0
votes
1 answer

read excel file with aspose version 2.5

I want to read excel file with aspose version 2.5, I know that in the latest version we can do this like : Workbook w = new Workbook(fileStream); Cells cells = w.getWorksheets().get(0).getCells(); I didn't found any documentation on aspose 2.5.
sabri
  • 5
  • 5
0
votes
1 answer

What is the .Net (C#) Apose.Cells equivalent of Excel VBA range -> ClearContents?

I am porting some Excel VBA code to .Net (C#) using Aspose.Cells. In the following example, the named range "SomeRange" refers to a collection of other ranges. ["SomeRange"].Value = (SomeRange1, SomeRange2, SomeRange2) Here is the VBA code…
JohnB
  • 3,921
  • 8
  • 49
  • 99
0
votes
1 answer

How do iterate over all cells in a named range in Aspose.Cells for .Net?

I'm working with .Net Apose.Cells. I am trying to figure out to iterate over all the cells in a named range. I retrieve the named range from the workbook: Range range = AsposeWorkbook.Worksheets.GetRangeByName(rangeName); I would like to set the…
JohnB
  • 3,921
  • 8
  • 49
  • 99
0
votes
1 answer

How do I run vba scripts embedded in a spreadsheet in .Net?

We have a .Net/C# based web service. Within the service, we use a spreadsheet as a calculationr engine. We're using Apose.Cells for .Net to populate the spreadsheet cells. Calculations are performed through VB script embedded in the spreadsheet. To…
JohnB
  • 3,921
  • 8
  • 49
  • 99
0
votes
3 answers

Asp.net WebApi Aspose.Cells - export and download excel

I use Aspose.Cells to create excel file. Actually I'm trying to save xls file on the disk and I can't resolve this problem. This is my get method. [Route("xls")] [HttpGet] public HttpResponseMessage Export() { try { …
adamo94
  • 507
  • 1
  • 6
  • 15
0
votes
1 answer

Aspose Cells for Java: get original CSV row

I am using Aspose to read a CSV file. I do not beforehand know the number of cells for each row of the file, but I will need to know it for further processing. Unfortunately, I see no way to find out the number of cells in a CSV row. Imagine the…
stefan.m
  • 1,912
  • 4
  • 20
  • 36
0
votes
1 answer

Pivot table refresh and save code in aspose cells for java corrupts excel file

I am using aspose-cells-8.7.2-java. When I refresh the pivot table and save it, the excel file is getting corrupted. When I try to open the excel file I am getting the alert message as below : "Excel found unreadable content in 'Book1.xlsx'.Do you…
Sowmya
  • 453
  • 1
  • 5
  • 18
1 2 3
…
20 21
Order Sheet