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
1
vote
1 answer

Dynamic sheet creation using Aspose cells in Java?

I am using aspose-cells.jar for Excel export in my application. I am stuck where I need to dynamically create sheets in the template. My original Excel template contains 2 sheets. Sheet1 contains the table and pie-chart. Sheet2 contains the data…
Vipul Ranjan
  • 35
  • 1
  • 6
1
vote
1 answer

Is there an Aspose way of getting text, including the line breaks/carriage return, out of a cell in Excel?

I have and Excel sheet that has data with line breaks in cells. So, for example, the text The quick brown fox jumped over the lazy dog would show up in one cell - let's say "A1" for simplicity's sake. I am pulling this into a string variable using…
wilsjd
  • 2,178
  • 2
  • 23
  • 37
1
vote
1 answer

Aspose-Cells: How do I evaluate a formula?

Given the following code: using Aspose.Cells // {...} Workbook workbook = new Workbook(); Worksheet virtualWorksheet = workbook.Worksheets[0]; virtualWorksheet.Cells[0, 0].Formula ="=1<2"; How do I evaluate the formula in Cell [0,0]? bool…
Jim G.
  • 15,141
  • 22
  • 103
  • 166
1
vote
1 answer

How does Aspose.Cells read/create MS Excel file

Does it have a dependency on something like a COM interface or OleDb that it installs as a redistributable package or does it read Excel Binary File Format directly? Just want to know how it works before I install it on my servers..
Ostati
  • 4,623
  • 3
  • 44
  • 48
1
vote
1 answer

Excel To image transformation

I want to convert my excel file as well as its entites(charts, tables, images) to jpeg/png images. Currently using aspose for that. Here is my code public static int excelToImages(final String sourceFilePath, final String outFilePrefix) throws…
Ashish Aggarwal
  • 3,018
  • 2
  • 23
  • 46
1
vote
1 answer

XlsSaveOptions(SaveFormat.Excel97To2003) issue in IE 8

I am generating a report in an MVC project. The user has the option of getting the report in either .pdf format or .xls I am using Aspose.Cells for the Excel file generation. The ActionResult method below is called. [HttpGet] public…
Mendelev
  • 23
  • 6
1
vote
0 answers

com.ctc.wstx.sr.ValidatingStreamReader cannot be cast to com.ctc.wstx.sr.ValidatingStreamReader

When I am trying to convert a xlsx file into pdf using this code else if (extension.equals("xlsx")) { //Createing and XLSX LoadOptions object LoadOptions loadOptions = new LoadOptions(FileFormatType.XLSX); …
Despicable
  • 3,797
  • 3
  • 24
  • 42
1
vote
1 answer

Aspose cells java, How to create image from table/ListObject

How to convert table/ListObject to and image? In excel file I have tables, charts and images and I am using aspose cells java. My requirement is to get all these details as an independent images and there are api's to convert charts and shapes to…
Ashish Aggarwal
  • 3,018
  • 2
  • 23
  • 46
1
vote
1 answer

Select range in aspose

Do you know an equivalent to VBA code: Range(Selection, Selection.End(xlToRight)).Select In Aspose.Cells. It seems that its only possible to select the last cell in the entire row: public Aspose.Cells.Cell EndCellInRow ( Int32 rowIndex ) Or the…
Mariusz.W
  • 1,347
  • 12
  • 19
1
vote
0 answers

Check excel versions (format) using vba

I want my VBA code to execute only if the file format is xls. Is this correct? I'm doing this: #If ActiveWorkbook.FileFormat = xlExcel5 Then //my code Else //my code #End if I tested using Excel 2010 (xlsm file) and it worked fine. I already…
periback2
  • 1,459
  • 4
  • 19
  • 36
1
vote
1 answer

Multiple groups of radio buttons on the same Excel worksheet using Aspose Cells

Is it possible to add more than one group of radio buttons to a single Excel worksheet using Aspose Cells for .NET? I've tried doing this, but they they all seem to share the same group. Adding the radio buttons inside GroupBoxes doesn't seem to…
Matthew Strawbridge
  • 19,940
  • 10
  • 72
  • 93
1
vote
1 answer

Error while saving Workbook using Aspose tool after Deleting a range of Cells

Before saving the Workbook I am deleting a CellArea in the Worksheet(I have used ClearContents, DeleteRange, ClearRange). But it keeps on giving an error "Specified argument was out of the range of valid values." However if i remove the delete code…
LetsKickSomeAss in .net
  • 536
  • 1
  • 8
  • 22
1
vote
1 answer

Aspose.Cells .NET: upgrading 6.0.1 to 7.3.1, WorkBookDesigner.SetDataSource() fails

Scenario: add two DataSets by invoking WorkBookDesigner.SetDataSource(DataSet) twice, each of the DataSets has a DataTable of customers, the DataTables have different names. 6.0.1: worked fine 7.3.1: Exception Test method…
Bart Strubbe
  • 107
  • 1
  • 7
1
vote
1 answer

C# Aspose.Cells.dll installation error

I have recently wrote a program in C#, and utilizing Aspose.Cells.dll in order to export my reports in Excel format. I installed my program on my computer and some of my friends' it works fine, but today when I faced a clean computer(which has no…
Ehsan
  • 4,334
  • 7
  • 39
  • 59
0
votes
1 answer

Read XML to Excel and back (maintain relationships)

Okay so I have the ability to write the XML to an excel file pretty easily (using Aspose.Cells) so that isn't the problem, I just need to figure out how I should write it into Excel so that I can maintain the relationships that the original XML…
MVarrieur
  • 513
  • 1
  • 5
  • 19
1 2 3
…
20 21