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

Add Tooltip using Aspose API for a PDF

I am trying add a tooltip text in a FTL template file to generate a PDF. Can anyone please help me how we can add it? Here is a sample: Hi How are you..! …
Surya Garimella
  • 317
  • 4
  • 13
0
votes
1 answer

How to display number with first digit as 0(Zero) in Excel using Aspose Cells

I need to display '0565' in Downloaded Excel. In datatable the value is '0565' but after assigning datatable to the worksheet, the downloaded excel shows value as '565'. It's an id I need to display it as it is '0565'. Below is my code …
Arun D
  • 444
  • 3
  • 7
  • 23
0
votes
3 answers

Read all the values of a cell in excel using aspose cells

I have an excel file in below format. col 1|col 2 | col 3 | status|some col| ------------------------------------- 1 | 23 | test | UDS | Test ------------------------------------- 12 | 2 | test2 | ADS | Test23 I need to read all…
blue
  • 833
  • 2
  • 12
  • 39
0
votes
1 answer

Expecting Cell Area instead of string in Java(Aspose)

hyperlinks.add("A5", 1, 1, "C:\\book1.xls"); The following error i get in my eclipse. The method add(CellArea, String, String, String) in the type Hyperlinks is not applicable for the arguments (String, int, int, String) Can anyone help me to…
Ajay Prajapati
  • 33
  • 5
0
votes
1 answer

Reading an excel with password protected sheet. While saving workbook password no longer stays

Here I am opening an excel file. Excel has a sheet which is protected with a password. myWorkBook = New Aspose.Cells.WorkbookDesigner myWorkBook.Workbook = New Aspose.Cells.Workbook(inFileName) After saving the sheet the worksheet remains…
niraj kasar
  • 1
  • 3
0
votes
1 answer

ASPOSE :How to Remove a Cell in ASPOSE

How to remove a specific cell from a row in aspose? The equivalent method of RemoveCell() in NPOI
Akash Patil
  • 1
  • 1
0
votes
1 answer

Can't able to use Formula in Excel while using Aspose.cells to import

I have been using Aspose.cells to import Excel sheet with data. The Excel sheet consists of a Salary column for which I am assigning Decimal value. Even though I am assigning the decimal value from the database the columns are assigned as string…
Arun D
  • 444
  • 3
  • 7
  • 23
0
votes
1 answer

regex evaluation so as to return all cells that are a match

FindOptions opt = new FindOptions(); opt.setRegexKey(true); opt.setLookAtType(LookAtType.ENTIRE_CONTENT); Cells cells = workbook.getWorksheets().get(1).getCells(); String regex =…
user4790067
  • 451
  • 2
  • 6
  • 12
0
votes
1 answer

Extracting rows that meet certain criteria from a worksheet and populating another worksheet dynamically using functions

My first worksheet has smart markers.The column names can be different each time. Can I populate a fresh worksheet with only those rows that meet a given criteria on one or more of the columns? Example: If the columns are TYPE and VALUE. Can I add…
user4790067
  • 451
  • 2
  • 6
  • 12
0
votes
1 answer

How to apply filters on rows in aspose cells for java

My excel file would have two columns - Type and value.After data has been inserted using smart markers, I want to add all the values belonging to the same type . How can this be done? Auto filter require range which I don't know as my excel file is…
user4790067
  • 451
  • 2
  • 6
  • 12
0
votes
1 answer

what data sources do smart markers accept?

I am using aspose cells with java. I want know what data sources do smart markers support. I know java objects are one of them. What others can be given? &=DataSource.FieldName &=[Data Source].[Field Name]
user4790067
  • 451
  • 2
  • 6
  • 12
0
votes
1 answer

Convert sheet (ideally range) to picture

is there a way to convert a range of a POI sheet to image (any extension) ? Is there an library that can help me do that (beside aspose) ? Thank you so much
Hamza Amamy
  • 31
  • 6
0
votes
1 answer

How can I set the column width in a spreadsheet to a specific pixel count (Aspose Cells)?

I am setting the width of a column this way: private static readonly int RESTAURANT_LOCATION_COLUMN_WIDTH = 28; . . . deliveryPerformanceWorksheet.Column(RESTAURANT_LOCATION_COLUMN).Width = RESTAURANT_LOCATION_COLUMN_WIDTH; The end user wants the…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
2 answers

How can I make an image used on multiple Excel spreadsheets always display at its full size (Aspose Cells)?

I am using the following code to place an image on a spreadsheet: var ms = new MemoryStream(); Image _logo = RoboReporterConstsAndUtils.GetURLImage("http://www.proactusa.com/bla/pa_logo_notag.png"); _logo.Save(ms, ImageFormat.Png); ms.Position =…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
2 answers

How can I assign a custom color to a cell in Aspose Cells?

In the legacy (Excel Interop) code, this can be done to assign a custom color to a cell: contractCell.Interior.Color = ColorTranslator.ToOle(Color.FromArgb(202, 134, 250)); Using Aspose Cells, I'm trying to find the corresponding way to do it. This…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
1 2 3
…
20 21