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

Memory not released after processing

I am facing a strange issue wherein a piece of code never releases the memory after finishing. The behavior is machine specific though, issue is seen on my VM running on Windows Server 2012-R2 (64-bit) with Intel Xeon CPU E5-2699, but doesn't occur…
Rajiv
  • 45
  • 9
1
vote
1 answer

PDF, HTML and SVG conversions are not working in Aspose.Cells

I have a .NET Core 2.0 project and use Aspose.Cells version 18.2.0. When I try to convert valid XLS to PDF, HTML or SVG, it fails. I'm using this code: Workbook doc = new Workbook(inputStream); // my input file stream doc.Save(outputStream,…
Andrew
  • 11
  • 3
1
vote
1 answer

Aspose cells memory leak issue with version 17.2

My goal to copy the excel data to SQL table by processing each cell (Need to have exactly same as excel data in SQL table). Currently we are using Aspose Cells version 8.2.0.0. During performance testing memory leaks are reported. So we are…
JyothiJ
  • 315
  • 1
  • 11
1
vote
1 answer

Font MTEXTRA.TTF issue after the last Microsoft security update

After the last Microsoft security update, the equation editor library was deleted, including its specific font (MTEXTRA.TTF). This causes a dysfunction in an application I'm working on. My App uses the Aspose Library to convert an Excel file into a…
Anis
  • 15
  • 4
1
vote
1 answer

how to embed ole object directly. without saving any file in disk

I already created a docx file by aspose.word and I need to embed an worksheet to this file thus I created a workbook and worksheet . Document doc = new Document(); Workbook workbook = new Workbook(); int i = workbook.Worksheets.Add(); Worksheet…
Aref Zamani
  • 2,023
  • 2
  • 20
  • 40
1
vote
1 answer

Aspose and umlauts (ä, ö, ü)

I use Aspose.Cells for java to convert excel documents to html. But there is problem with umlauts. there is the code I use to save excel documents to html com.aspose.cells.Workbook workbook = new…
Anton
  • 11
  • 1
1
vote
0 answers

using a c# foreach on List to check for default date values

I initially wanted to quickly select certain records (using a Linq qry) which match a default date condition (01/01/0001) - var defDates = (from rec in myRecords where rec.myDate == System.DateTime.MinValue select rec.myDate); and then update…
bob.mazzo
  • 5,183
  • 23
  • 80
  • 149
1
vote
1 answer

Exporting OpenXML based Charts into images

Can I generate image from office OpenXml based chart definition? My idea is to use the program dynamically generate OpenXml definition of a chart and export it as image.
Subhash Makkena
  • 1,909
  • 2
  • 13
  • 15
1
vote
0 answers

Keeping a cell with the Specific Data at Last

I’m trying to Sort The Data. Which is working Perfectly fine . And If I need some Specific Data to be on top I give it as sorter.add(0,SortOrder.ASCENDING,"to be top Data"); in Aspose API Java. But What Can I do For the Data to be always on the…
user7569898
1
vote
1 answer

Base64 excel file stream Aspose.Cells.CellsException

I have a Base64 string of xls file. When I try to open base64 stream it throws the following exception Aspose.Cells.CellsException : This file's format is not supported or you don't specify a correct format. public Stream…
zapoo
  • 1,548
  • 3
  • 17
  • 32
1
vote
0 answers

Read excel object in excel file using aspose error

I'm using Aspose Cells for .NET in my ASP.NET MVC project. First I read the Excel objects in Excel files and than using File.WriteAllBytes to save the Excel object , but it can't be read. I opened the saved Excel files, but MS Excel just shows a…
1
vote
1 answer

How to set Text format to a particular column in Excel using Aspose Cells

I am using Aspose Cells and I need to convert a particular column to text format, as the column consists of both numbers and Text, by default the column is taken as number format. I have used Aspose.Cells.Style style =…
Arun D
  • 444
  • 3
  • 7
  • 23
1
vote
1 answer

Can I use Aspose.Cells dll free with microsoft visual studio?

I was wondering if I can use Aspose.Cells.dll. I downloaded it from the their website. https://downloads.aspose.com/cells I'm curious do I just need to add the dll to my project? Can they charge me or my workplace? Is the Dll file that I downloaded…
abdullahDev
  • 39
  • 1
  • 6
1
vote
1 answer

How to generate excel report with aspose cells that has dynamic date columns?

As I am new to Aspose as well as oracle , facing trouble in generating excel.I want to generate a excel file from aspose .net. The problem of mine is as follows: I have a data in coming out from oracle database in the following…
RachitSharma
  • 567
  • 4
  • 11
  • 31
1
vote
1 answer

Excel sheet comments in C#

I have a list that is filtered from SQL and an excel sheet that stocks them. In that list I have a column named A. If that column exists, a comment should appear at the header of that column. Its position might change, so I can't use this: int…