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
2
votes
3 answers

Excel Week Column Sorting in Ascending Order

I have a Week Range Data as Below which has Start date of the Week and End Date in mm/dd/yy -mm/dd/yy format, I'm Trying to Sort the Column but it doesn't get Sorted as required, Help me on this…
user7569898
2
votes
1 answer

Worksbook saved with stream is broken

recently I was trying to save Aspose.Cells.Workbook to stream with private Stream GetWorkbook() { // processing workbook here // ... // saving to stream return workbook.SaveToStream(); } private void Save() { using (stream =…
Max
  • 93
  • 1
  • 2
  • 12
2
votes
1 answer

Insert page number with text in footer aspose word java

I want to insert page number in footer alongside with text, but when footer contains some text, page number and text in footer switch places. I am doing this while converting document from html to word using aspose words java library. Text in footer…
Lemmy
  • 2,437
  • 1
  • 22
  • 30
2
votes
1 answer

Why is my background color not applied (Aspose Cells)?

I'm trying to add a color to the background of my cells like so: style.BackgroundColor = Color.LightBlue; style.Pattern = BackgroundType.Solid; In more context: Cell shortNameHeaderCell = locationWorksheet.Cells[BYDCBYLOC_HEADING_ROW,…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
2
votes
1 answer

Using Aspose.Cells for .NET to read/write file's "Version number"

An existing Excel file has a version number: How do you read/write this version number using the Aspose.Cells API? I did not find this in the documentation or when debugging the Workbook object.
Bernard Vander Beken
  • 4,848
  • 5
  • 54
  • 76
2
votes
1 answer

aspose excel GetCellIndex index out of bounds for empty cells

I am using Aspose Cells to get data from excel file in each row I have data like this | Name | PhoneNumber | Email | Group | Jack | +1456985 | | Users When I try to read contact from row with this…
Mahyar Pasarzangene
  • 373
  • 8
  • 23
2
votes
2 answers

How to format cells in Aspose

I am trying to make a piece of text bold at a particular cell but not able to. This is the code I am using: Style boldStyle = workBook.CreateStyle(); boldStyle.BackgroundColor = Color.Red; StyleFlag boldStyleFlag = new…
Charu
  • 2,679
  • 6
  • 35
  • 52
2
votes
1 answer

Apply multiple styles in one cell in Aspose-Cells

I want to add multiple styles in one cell. EX: I Want Some Help Now I dont have the full text at a time. I only have a chunk at a time (Like, "I", "Want", "Some", "Help" and associated style) . But I need to set the whole string formatted in one…
Mahfuz
  • 381
  • 2
  • 10
2
votes
2 answers

Issues with VB and Aspose

I have the following lines of code: Dim ms As New MemoryStream(my_memory_stream) workbook As New Workbook(ms) workbook.Save("C:\book1.xlsx") My purpose is to save the stream contained in my_memory_stream into an xlsx file named "book1": the problem…
Daniele Milani
  • 553
  • 2
  • 7
  • 26
2
votes
1 answer

Aspose.Cells - Set Border For Range

I'm currently working with Aspose.Cells. I've largely managed to do what I need to do however one issue remains; I can't see an easy way to apply a border to a defined range. I can for a cell, however when applying the style to the range all cells…
ZX80
  • 21
  • 3
2
votes
1 answer

Aspose cell exception:om.ctc.wstx.sr.ValidatingStreamReader cannot be cast to com.ctc.wstx.sr.ValidatingStreamReader

I am using Aspose.Cells (trial version) to parse a .xls (Excel) file for Java. But when I try to load the file, it throws the exception given below: SEVERE: java.lang.IllegalStateException: XML Stream Exception: XMLStreamException:…
Freak
  • 6,786
  • 5
  • 36
  • 54
1
vote
1 answer

MVC3 Aspose error on LoadData

I have an MVC3 C#.Net web app. I am using the Aspose library to read an Excel file using the WorkBook.LoadData() method. I am able to Load a file from my local machine when running in Visual Studio. I am able to load a file from the web server…
MikeTWebb
  • 9,149
  • 25
  • 93
  • 132
1
vote
1 answer

ASPOSE.Cell -How to read the calculated value from a AddIn Formula Cell

I am using ASPOSE.Cell Component to read an Excel. I am able to read normal values from cells. But in my excel few cell values are driven by Add-In formulas, which i am not able to read. When i read the value of those cells using cell[].Value, i am…
KBBWrite
  • 4,373
  • 2
  • 20
  • 22
1
vote
1 answer

How to use LightCells Api to read and write large excel files in Aspose.Cells

I want to make use of the LightCells API within Aspose.Cells to help optimize my read and write processes while also reducing the memory utilization while processing the excel file. I have queries regarding the implementation of this API. How can I…
Vaibhav Karale
  • 11
  • 2
1
vote
2 answers

Aspose Worksheet not parsing decimal numbers correctly on German server; ignoring period delimiter (123.45 -> 12345)

I have an import task that parses a huge .dat file as an Aspose Workbook. This was the original code: public static List GetAsposeExcelDocumentWithSheetIndex(string filename, string propertyNames, int sheetIndex = 0, int skipRows =…
Erica Stockwell-Alpert
  • 4,624
  • 10
  • 63
  • 130
1
2
3
…
20 21