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

Why is my font and background (foreground) colorization not working here (Aspose Cells)?

In two places on my sheet, I need cells that have white font and a black background. In one place (the header row), it works; in the other (a date value), it doesn't, and I don't see what I'm doing differently that would cause this failure. Here is…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

What corresponds to a Zoom value of false in Aspose Cells?

I'm refactoring some Excel Interop code to utilize Aspose Cells. One of the legacy lines of code related to printing a sheet is: xlSheet.PageSetup.Zoom = false; Aspose Cells does have a [Sheet].PageSetup.Zoom property, but it is an int, not a bool.…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
2 answers

Do I need to use an older version of Aspose.Cells.dll?

I am Asposisizing a legacy app (users complained about the slowness of the code, which is in Excel Interop). I have added a reference to Aspose.Cells.dll and added this using: using Aspose.Cells; ...but get this compile error: The type or…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
2 answers

Why would cell contents set to align left sometimes align right (Aspose Cells)?

I've got this code, which should left-align the contents of a particular column: Cell memberItemCodeCell = customerWorksheet.Cells[rowToPopulate, MEMBERITEMCODE_COL]; memberItemCodeCell.PutValue(frbdbc.MemberItemCode, true); var micStyle =…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

Why are borders not being applied to my top row (Aspose Cells)?

I've got the following code to add borders to a row: Range _range; _range = customerWorksheet.Cells.CreateRange("A1", "P1"); _range.SetOutlineBorders(CellBorderType.Hair, Color.Black); ...but it's not working - no borders appear on that top row…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

C# Aspose.Cells set data to Excel file with format

I have search around the web but could not find any solution. I have a Excel file used as a template, with a area to parse data from DB. Among the columns of the Excel file, there is a number column with a custom format. My code (C#) of setting data…
N.D.H.Vu
  • 127
  • 1
  • 16
0
votes
2 answers

How can I programmatically convert a string to number to remove the green warning triangle (Aspose Cells)?

I have two columns in my sheet wherein each cell has the green warning triangle with the message, "The number in this cell is formatted as text or preceded by an apostraphe." I can manually clear these green warnings triangles in Excel by selecting…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

Why does this code not set the background color for a cell (Aspose Cells)?

I need a cell to have a light blue background color; I have code that works in another sheet, but the same exact code (except for the names of the vars and column index val): Style styleShipVariance = null; CellsFactory cfShipVariance = new…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

Why is a subsection of my range failing to add borders (Aspose Cells)?

Based on code from here, I added the following: string bottomRightRange = string.Format("F{0}", rowsUsed); var range = locationWorksheet.Cells.CreateRange("A8", bottomRightRange); //Setting border for each cell in the range var style =…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

How can I add borders around a spreadsheet range (Aspose Cells)?

I want to add borders to a range on a spreadsheet. Based on some VB code here, I tried this: Range range = locationWorksheet.Cells.CreateRange(7, 0, 93, 6); range.SetOutlineBorder(BorderType.TopBorder, CellBorderType.Thick,…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

Why is my style not being applied to my range (Aspose Cells)?

I am creating a range, giving it a value, and styling it up like so: private string fontForSheets = "Calibri"; Range unitNameRange = locationWorksheet.Cells.CreateRange("A1", "D1"); unitNameRange.PutValue(_unit, false, true); // val, isConverted,…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
2 answers

What do I need for CellRange to be recognized (Aspose Cells)?

I need to define a range of cells using Aspose. I found the following example here: CellRange range = new CellRange(6, 1, 6, 4); However, with this code: using Aspose.Cells; . . . CellRange unitNameRange = locationWorksheet.Cells[1, 1, 1, 4]; ...I…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

How can I color all the related rows and columns, rather than just a subset of them (Aspose Cells)?

I had a related question heretofore, and the answer there that (pretty much) works for me is to use: pt.ShowInCompactForm(); In a spreadsheet I generate, there are blocks of items that span 5 rows - the first row is a Description, and the four rows…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

What should I do to increase the size on the page of Excel printouts using Aspose Cells?

A user is complaining that the printing of a spreadsheet is too puny, and wants it enlarged on the page to be (more) legible. What do I need to change to increase the size of the printed area? I have this code to set up the printing…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

Aspose.cells custom date formatting irrespective of OS date format

I am currently using aspose.cells for .Net and need to set a custom format a date based on the current language being used in our app. Issue is, we are setting the format via code below, but if the system(OS) date format is different, our custom…
Gautam Baindur
  • 36
  • 1
  • 6
1 2 3
…
20 21