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
27
votes
4 answers

Can Excel interpret a cell as HTML?

I'm using Aspose.Cells to build an Excel document programmatically. This works great. One of the cells, though, is a block of raw HTML. I'm wondering if it is possible to tell Excel (in any fashion, including the GUI - you don't need to know the…
Greg Smalter
  • 6,571
  • 9
  • 42
  • 63
14
votes
1 answer

do all packages in nuget have free licence to use?

I am working on a project which require manipulating Excel files. I found a library for this job called Aspose.cells. it is not a free library and we should buy its licence from its site in order to use it in our projects. However, I found that…
soroush shirali
  • 141
  • 1
  • 1
  • 5
10
votes
1 answer

How do I get a byte array from HttpInputStream for a docx file?

I am using the method from the first answer in this post: How to create byte array from HttpPostedFile but it doesn't work for .docx files for some reason. //viewmodel.File is HttpPostedFileBase byte[] fileData; using (var binaryReader = new…
wilsjd
  • 2,178
  • 2
  • 23
  • 37
9
votes
1 answer

Style lost when combining workbooks with aspose

When combining many Excel files with aspose, I get a single workbook (Excel file with many sheets). But the problem is that I don't get the HTML style(color, font, size background color...) which was in each sheet before the merge. Here is my java…
amani92
  • 903
  • 8
  • 22
6
votes
2 answers

Aspose.Cells for .NET Enable Data Filtering

I just started working with the Aspose.Cell's library for .NET and am having some issues finding documentation on how to enable Data Filtering for an output Excel sheet. I understand this functionality is built into Aspose.Cells.GridWeb and…
JeffreDodd
  • 244
  • 5
  • 12
5
votes
3 answers

How to add a JAR file to an existing gradle project?

I have a jar file for Aspose Cells for Java that I want to add to an existing Gradle project in IntelliJ IDEA 2017.2.1. If I go to View -> Tool Windows -> Gradle, I see the gradle window like so but I don't know what to click. I tried right-clicking…
Water Cooler v2
  • 32,724
  • 54
  • 166
  • 336
3
votes
1 answer

How to speed up workbook creation with Aspose?

I am working on some code in which I have to open excels, change some cells values and then re-calculate the formulas of the whole file in order to get two specific values and inform them. The problem is that I have to do this with a high number of…
Andrew123
  • 33
  • 6
3
votes
0 answers

Why does GetManifestResourceStream fail at runtime?

I am running into a hard to reproduce bug in production code where I am seeing GetManifestResourceStream return null at runtime. Context: I am running a Service Stack service self hosted as a Windows Service. This service wraps 3rd party software…
yenta
  • 1,332
  • 2
  • 11
  • 25
3
votes
1 answer

How to copy one worksheet to another worksheet on within workbook using aspose.cell

How can i copy one worksheet values and paste an another worksheet on within a workbook in aspose.cell using asp.net with c#? Thanks and regard, Parthiban K.
Parthiban
  • 35
  • 2
  • 4
3
votes
1 answer

Is it possible to unlock specific cells in a protected sheet (Using Aspose)

I'm using Aspose-Cells and java to export excel templates in my system. In this particular situation I'm generating a spreadsheet where I have two sheets that I want to protect. In one of them, I need to let the user edit only 4 cells. All the rest…
periback2
  • 1,459
  • 4
  • 19
  • 36
3
votes
1 answer

Aspose xlsx and pptx files conversion exception

I am using these jar files to convert excel and power point files to PDF aspose.slides-6.7.0.jar aspose.slides-6.7.0-jdk14.jar aspose-cells-7.3.4.jar Aspose is converting ppt and xls files perdectly but it throws exception on xlsx and pptx…
Despicable
  • 3,797
  • 3
  • 24
  • 42
2
votes
1 answer

setting one worksheet cell range reference to another worksheet using aspose.cells or MS-Excel

I want to set one worksheet cell range reference to another worksheet using aspose.cells or MS-Excel.For example i have two worksheet(wrk1 and wr2). I have some data on wrk1 and wrk2 is balnk.Now on wrk2 i want cells refrence of wrk1(like want cell…
KAPIL BHATIA
  • 99
  • 1
  • 6
  • 14
2
votes
1 answer

How to have Aspose.Cells 19.10 correctly render fonts in Linux .Net Service?

I am building a .net service in docker that will take .xlsx files and render them as .tiff. When I run my service locally on a windows environment the images correctly render with Times New Roman text. When I spin up a docker container and submit…
dwagner003
  • 21
  • 1
2
votes
3 answers

Is there a way to get Worksheet from the Cell in Aspose Cells?

I'm looking for something like myCell.Parent or myCell.Worksheet to get the Worksheet object of a Cell in Aspose cells for .net. I didn't see any property on the Cell class that refers the Worksheet. Wondering if there is a way that I missed?
gsharp
  • 27,557
  • 22
  • 88
  • 134
2
votes
1 answer

Aspose CheckCell vs Aspose WorkSheet.Cell[r,c]

My excel has millions of records (approx 1.1M) and when I am trying to read cell by cell using WorkSheet.Cells[row,cloumn] it is very slow. Rather if I use, WorkSheet.Cells.CheckCell(row, column) performance is very good. Can you please let me know…
JyothiJ
  • 315
  • 1
  • 11
1
2 3
…
20 21