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

Aspose.Cells wrap the terms between triple double quotes

Using Aspose.Cells I need a csv file with my terms wraped between double quotes. For some reason the terms after the first column are surrounded by triple double quotes when saving my csv file, like: """term""" This is my code: WorkbookDesigner wd =…
Rafael
  • 1,099
  • 5
  • 23
  • 47
0
votes
1 answer

Add a Macro Button to a Worksheet Using the Aspose.Cells API

How do I enable calling a macro on a button click via the Aspose.Cells API? I couldn't find any documentation on it. "Guessing" approach didn't yield any result either.
pangular
  • 699
  • 7
  • 27
0
votes
1 answer

Cannot Retrieve Data from Excel File Created using Aspose.Cells

I create an Excel file (.xlsx) using the Aspose.Cells library. But I'm not able to read the data (retrieve rows) using OleDb commands after that, until I open the file and save it manually. I'm running something as simple as this one: new…
pangular
  • 699
  • 7
  • 27
0
votes
1 answer

Replacement for BuiltInDocumentProperties, When upgrading .Net project's Aspose Cells from 4.7.1.0 to 8.4.0?

I just tried to set a new reference for DLL Aspose cells 8.4.0. And i see so much error, since the properties or objects that is not supported in new version of aspose cells. -…
pvaju896
  • 1,397
  • 6
  • 25
  • 46
0
votes
2 answers

Aspose Cells AutoFitMergedCells

I have an .xls document with cells merged vertically, horizontally and vertically & horizontally at the same time. My code is: Workbook wb = new Workbook(inPath); AutoFitterOptions options = new AutoFitterOptions(); options.AutoFitMergedCells =…
Maksim
  • 264
  • 7
  • 20
0
votes
0 answers

combine candlestickOHLC into a single stockchart OHLC

i'm having a candle stick chart (stock chart OHLC) which shows more than one company data in a single chart, for a single chart i'm able to draw chart, but with multiple company data, i'm unable to draw chart. using "aspose.cell" for .net.…
Annadate Piyush
  • 458
  • 5
  • 18
0
votes
0 answers

Why is Aspose.Cells not saving my updated formulae containing external references?

(Using Apose.Cells 8.3.2.1) We have a large number of Excel 97-2003 spreadsheets with large numbers of named ranges in them. We need to upgrade them all to Excel 2010. Unfortunately a lot of the named ranges are of the form ABC1234 which is now a…
adhocgeek
  • 1,437
  • 1
  • 16
  • 30
0
votes
1 answer

How to work with filtered results using Aspose Cells

In my work i am using cells-2.3.1.jar. I want to filter columns and work with those filtered values, without save to file and reload it, just working in memory. This is my code: Worksheet worksheet = workbook.getWorksheets().getSheet(0); …
user2514849
  • 48
  • 5
0
votes
1 answer

Ungroup All Columns in Aspose Cells Worksheet

I currently have a worksheet with many existing column groupings. I want to remove ALL those groups. The following code does not work: cells.UngroupColumns(cells.MinColumn, cells.MaxDataColumn + 1); Any suggestions?
Pouya Barrach-Yousefi
  • 1,207
  • 1
  • 13
  • 27
0
votes
1 answer

Aspose-Cells: Autofilter on worksheet with more then 26 columns

I'm in kind of a bind here. I need to set an autofilter on a worksheet. To do this I normally use the following code: Here Columncount is the number of columns visible Dim alphabet As String =…
User999999
  • 2,500
  • 7
  • 37
  • 63
0
votes
1 answer

Why is Aspose.Cells cutting off the top half of my text when I export to PDF (or TIFF or XPS)?

I'm using Aspose.Cells to create a report to be exported to both Excel and PDF. In cell A1, I have some text that I've given a font size of 20. When I save this workbook to a PDF file, the top half of the text is getting cut off. Here's a…
user2023861
  • 8,030
  • 9
  • 57
  • 86
0
votes
0 answers

Aspose-Cells (Java) connect two shapes

It is possible to connect two shapes with a connector shape? I know how to create shapes: private static void createShapes(Worksheet worksheet) { Shape rectangle1 = worksheet.getShapes().addAutoShape(AutoShapeType.RECTANGLE, 3, 2, 3, 0, 12,…
Binzer
  • 11
  • 1
0
votes
1 answer

Issue with aspose.cell ”.HtmlString” property ,When html tag text contain character “&”

HTML Status: REGISTERED 8 **&** 15, June 20,…
Jack
  • 3
  • 2
0
votes
1 answer

Encoding conflict

I have a problem with retrieving data from .csv file (windows-1251 encoding). I use Aspose Cells and here is my code: public static IEnumerable ElmarketByParce(string filePath) { if (String.IsNullOrEmpty(filePath)) …
iOne
  • 153
  • 2
  • 12
0
votes
1 answer

Converting MS Word API to Aspose Word API

Could you please provide code for converting the following VB code using MS Word to VB.NET using Aspose Word? Dim os AS Excel.Worksheet oS.Range("A55", "S55").Select() oS.Application.Selection.Copy() …
willsonchan
  • 200
  • 2
  • 14
1 2 3
…
20 21