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

Aspose Cells - Change named range reference

I have a named range that current refers to A1:I8 in a worksheet. I would like to change it to refer to a larger part of the worksheet. Does anyone know of a method in Aspose that does this? Or a method that lets me delete the existing range in…
lala
  • 83
  • 2
  • 9
0
votes
2 answers

Setting data in xml using java and aspose

I am not able to set any data after each column,suppose i have column like a1,a2,a3 i am able to set only for a1 and a3 not a2.I am using aspose to set data in xml and generate xml.What is wrong i am doing here ? Worksheet workSheet =…
pars
  • 153
  • 2
  • 4
  • 11
0
votes
2 answers

Setting data in XML using aspose

I am trying generate excel sheet using aspose. I have generated the excel sheet and I am trying add few data into it. I have added Response at cell A4. I want to add Date at cell B4 and Time at cell C4. I am not able to add B4 and C4…
pars
  • 153
  • 2
  • 4
  • 11
0
votes
1 answer

I am getting a blank spreadsheet called "object" on my export

I am running C#.NET, and Aspose version 7.3. When I export my sheet, it exports completely fine. No problems. Nuttin but love. However, when I click 'save as' in the browser options (as opposed to 'open'), and open that resultant file, there is an…
user426364
  • 160
  • 9
0
votes
1 answer

Disabling automatic encapsulation on export

I've inherited a project at work recently that was written by one of our less skilled interns. It's fairly straightforward in theory; it just needs to export some data from a server to a CSV file for a vendor. The problem is that our vendor needs to…
Logarr
  • 2,120
  • 1
  • 17
  • 29
-1
votes
1 answer

Download Excel file from a MemoryStream in C#

I'm having a problem downloading a Excel file in browser using React.js. Here is the situation: I have written an API which will take an Excel file as input , then after modifying it using Aspose Cells I have saved it as a memorystream.Then…
Suprateem Bose
  • 59
  • 6
-1
votes
1 answer

Read too large CSV with with c#

I have to extract specifict information from a too big CSV file with C#, the file is 233 MB in size, it has 1000008 rows and 28 columns and insert tha information in a datatable. actually i tried with OleDB and Aspose.cells, but both ways are too…
Scott Guani
  • 1
  • 1
-1
votes
1 answer

Saving XLSB with structure protection, creates encrypted file format

So I’m loading a XLSB file into a workbook using Apose.cells (21.5.0) then saving it out. The issue I’m having is that the produced file will out open, when the original file opens just fine. Below is a walkthrough of what I have found. Code being…
Ian Macnichol
  • 1
-1
votes
2 answers

Aspose Cells. Get rows by group

How can I read rows by group using Aspose? example
L Brg
  • 1
-1
votes
1 answer

Convert string to Aspose.Cells.Name

I am trying to check, if the name of the sheet already is in the other workbook. I am currently trying it like this: if (tempWb.Worksheets.Names.Contains(ibbWs.Worksheets[index].Name)) { ... } How can I fix that or convert a string into a…
probst
  • 196
  • 1
  • 1
  • 12
-1
votes
1 answer

How to display multi level headers in Aspose cells Java in MS Excel?

Please let me know if Aspose Cells Java API provides a way for doing this? Please see the attached pic as below : enter link description here
Balakumar Seethapathy
  • 41
  • 2
-1
votes
1 answer

How to solve SystemOutOfMemory Exception

I am getting below exception in my application at line: Workbook workbook = new Workbook(fstream); Exception: Exception of type 'System.OutOfMemoryException' was thrown. C# Code: string tempPath = @"C:\File\01_TDv01.xlsx"; foreach (string…
timz_123
  • 435
  • 1
  • 9
  • 47
-1
votes
1 answer

Skip the content while HTML to Excel conversion using aspose.cell in Java

I want to convert the HTML to Excel using aspose cell in Java, but the generated Excel skipping the content. HTML content : Hi Fanny, Urgent !!  SPR'17 - S/545175 -- ADSO# 16843754; SPR'17 - S/545175 -- ADSO# 16843754; …
pankaj
  • 11
  • 6
-1
votes
3 answers

How can I prevent "#Div/0!" in calculated cells (Aspose Cells)?

I am generating a spreadsheet with this calculated field: pivotTable.AddCalculatedField("Average Price", "=TotalPrice/TotalQty", true); It works like a charm most of the time, but once in awhile there are 0-values, and thus produce a "#Div/0!",…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
-1
votes
1 answer

How can I order a PivotTable's ranges by the value in a particular cell (Aspose Cells)?

I need to order the ranges (each range covers four rows) by a value in one of that range's cells. This is how the first bunch of data looks: I need to order these by the value in the cell at the juxtoposition of "Sum of TotalPrice" and "Grand…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
1 2 3
…
20
21