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

How can I prevent my image from changing size when placing it on a spreadsheet (Aspose Cells)?

I have an image that is embedded in my solution and is used on the main form of a Winforms app, and also for pasting into a spreadsheet. The image size is 156X121. I put it on the sheet like so: var ms = new MemoryStream(); _logo.Save(ms,…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

How can I hide selected ranges AND sort the displayed results (Aspose Cells)?

I can sort (descending) my displayed results by a selected value using this code: PivotField field = pivotTable.RowFields[0]; field.IsAutoSort = true; field.IsAscendSort = false; field.AutoSortField = 1; This is what I see (Total Purchases…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
2 answers

How can I override the column label text on a Pivot Table (Aspose Cells)?

I am using source data that contains values such as "10/1/2015", "11/1/2015" etc. Understandably, when I add these values as a Column PivotFieldType: pivotTable.AddFieldToArea(PivotFieldType.Column, MONTHYR_COLUMN); pivotTable.ColumnHeaderCaption =…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

Is there a way to FreezePanes (on a Pivot Table) in Aspose Cells?

I'm porting a slower-than-molasses-on-the-Ross-Ice-Shelf Excel Interop app to Aspose Cells. One feature I'm trying to port over (can't find the way to do it here) is "FreezePanes" My legacy (Excel Interop) code is commented out; it works; my attempt…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
3 answers

Why does setting a color to a cell not work (Aspose Cells)?

I have this code to try to set the background color of a cell (among other things): private static readonly Color CONTRACT_ITEM_COLOR = Color.FromArgb(255, 255, 204); . . . cell = pivotTableSheet.Cells[4,…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

How can I coerce generated values in a PivotTable to adopt a specific format (Aspose Cells)?

I have code to create data fields (and then give their labels user-friendly strings) like so: pivotTable.AddFieldToArea(PivotFieldType.Data, TOTALQTY_COLUMN); pivotTable.AddFieldToArea(PivotFieldType.Data,…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
2 answers

How can I replace automatically-generated grand total values with different ones (Aspose Cells)?

My spreadsheet automatically generates a "Grand Totals" column as the rightmost column: This is nice, in general. But in specific, I've got a couple of problems with it: The last two values (with the unfortunate labels "Sum of Avg Price" and "Sum…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

How can I place my data fields beneath my row field in my PivotTable (Aspose Cells)?

I have a PivotTable created with Excel Interop that places the data field values beneath the row field values, like so: When I create the PivotTable with Aspose Cells, the data fields are 1:08 PM 11/18/2016in a column to the right, rather than in…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

Why does attempt to color ranges in a PivotTable have no effect (Aspose Cells)?

I'm trying to conditionally colorize ranges in a PivotTable like so: private void ColorizeContractItemBlocks(List contractItemDescs) { int FIRST_DESCRIPTION_ROW = 7; int DESCRIPTION_COL = 0; int ROWS_BETWEEN_DESCRIPTIONS = 4; …
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

Why is a cell with a value seen as being null (Aspose Cells)?

I need to loop through a PivotTable and colorize certain ranges. I'm trying to do that with the following code: private void ColorizeContractItemBlocks(List contractItemDescs) { int FIRST_DESCRIPTION_ROW = 7; int DESCRIPTION_COL =…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
2 answers

How can I determine how many rows a PivotTable generates (Aspose Cells)?

I need to conditionally colorize ranges in a PivotTable. I tried to do it this way: private void ColorizeContractItemBlocks(List contractItemDescs) { int FIRST_DESCRIPTION_ROW = 7; int DESCRIPTION_COL = 1; int…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

How can I vertically center a value in a PivotTable cell with Aspose Cells?

I know how to vertically center cell values when they can be defined by their row location, namely get a reference to them, create a style, assign values to the style, and then assign the style to the cell, like so: cell = pivotTableSheet.Cells[4,…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

How can I provide a calculated value that is based on two other values in an Aspose.Cells PivotTable?

I am adding data fields to a PivotTable like so: int TOTALQTY_COLUMN = 4; int TOTALPRICE_COLUMN = 5; . . . pivotTable.AddFieldToArea(Aspose.Cells.Pivot.PivotFieldType.Data,…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

How is it possible to put a PivotTable on a different sheet using Aspose Cells?

I see here how to create a PivotTable on the same sheet as the source data, like so: int index = pivotTables.Add("=A1:C8", "E3", "PivotTable2"); The first arg ("=A1:C8") is the source data to extract, the second ("E3") is the cell that will serve…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

Aspose workbook copy/rename sheet

I want to Copy Sheet from excel, create copy of sheet with particular name. Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook(excelFilePath); //Create a Worksheets object with reference to the sheets of the Workbook. …
Bokambo
  • 4,204
  • 27
  • 79
  • 130
1 2 3
…
20 21