I want to put an html string to a workbook cell (with some html element contains rgba in css style) ,and then I use HtmlString, but this operate throw a error about rgba(255 is not a valid value for Int32
The version I have using is Aspose.Cells 19.4.0

//Datatable data

for (int i = 0; i < rows; i++)
{
    for (int k = 0; k < columns; k++)
    {
        cells[1 + i, k].HtmlString = data.Rows[i][k].ToString();
        cells[1 + i, k].SetStyle(style);
    }
}       

I tried the following ways to change the width of second column in my worksheet.But nothing worked.I seee that hte width is still the same as before. Is there something I am missing?

w.Cells.SetColumnWidthPixel(2, 10);
w.Cells.SetColumnWidthInch(2, 10);
w.Cells.SetColumnWidth(2, 10);

when copying a worksheet from a workbook that has named ranges to another workbook, the Named Ranges get copied but when you try

var sourceFile= new Workbook(@"c:\test1.xlsx");
var destinationFile= new Workbook(@"c:\test2.xlsx");

var newSheetIndex = destinationFile.Worksheets.Add();workbook.Worksheets.GetRangeByName
using (var newSheet = destinationFile.Worksheets[newSheetIndex])
{
                newSheet.Copy(sourceFile.Worksheets[sourceSheetIndex]);               
                destinationFile.Save(@"c:\test2.xlsx");
}
var range = destinationFile.Worksheets.GetRangeByName(rangeName);

throws a null exception at the GetRangeByName call.
also, if you look at the newly created worksheet, it's Workbook property is set to null

Aspose.Cells 是否支持 NET CORE 2

1. Here's what I want,
   

The last two columns have no values ​​and I want to keep empty strings in the json.

Hi Team,

I am unable to export the data in an .xlsx. The data size is huge(around 25000 and above). I tried 2 cells dlls. (8.5.1.0 and 8.8.2.0) .

Source: Aspose.Cells
TargetSite: Void AutoFitColumn(Int32)
Message: Invalid column index.

Attaching the code snippet and blank page snap.

Please assist
code snippet.txt

Aspose.Cells for Android via Xamarin？

Aspose.Cells fails to open the csv link below which could be opened by Office withotu any issue.
https://www.federalreserve.gov/econres/notes/feds-notes/FEDS-Note-2873-cie-data.csv

hi,

i use below code to encrypt excel's specific sheet, but not work, for Workbook, i can encrypt successfully:

        string excelFile = Path.Combine(currentDirectory, "test.xlsx");
        string encryptedfile = Path.Combine(currentDirectory, "encryptedtest.xlsx");
        Workbook workbook = new Workbook(excelFile);
        workbook.Worksheets[0].Protect(ProtectionType.All, "1234", "");
        // Save the excel file
        workbook.Save(encryptedfile);

so what should i use to let it work, i use aspost.cells version as below:
Aspose.Cells: 20.11.0
OS: Windows10

I am getting many errors when running the GridWeb.Net6 sample such as

In GridController.cs

1. The type or namespace name 'AcwController' does not exist in the namespace 'Aspose.Cells.GridWeb' (are you missing an assembly reference?)

2. An object reference is required for the non-static field, method, or property 'MainWeb.SessionStorePath' GridWeb.Demo.NET6.0

3. Reference to type 'WebControl' claims it is defined in 'System.Web', but it could not be found

Steps to reproduce:

1. Download the repo
2. Navigate to folder "Aspose.Cells-for-.NET-master\Examples_GridWeb\GridWeb.Net6"
3. Open "GridWeb.Demo.NET6.0.csproj" in VS2022
4. build the solution

Is there anything i need to import or install in order to run this example?

I also tried to follow the guide below but got the same issues as the sample
https://docs.aspose.com/cells/net/how-to-use-aspose-cells-gridweb-with-net-core/

On compile, the error appears that a file is missing: ...\Aspose.Cells-for-.NET-master\Aspose.Cells-for-.NET-master\Examples\CSharp\Files\Handling\SaveSXCFiles.cs' could not be found.

Dear,

I have an excel template with 12 columns for header with different widths.

I need to hide header column if all rows after my header row are empty, so my exported files could contains any titles between 1 and 12 titles.

I manage to do the hiding part by dynamically checking my conditions and let's say that I have columns A, B, C with titles.

How to expand my content to the column M (limit of my printing area) with autoMerge cell with the good individual width to allow all rows next to be display correctly if I have a 500 letters text to display in the colum C for example.
Just to prevent all my columns to occupy only 20% of the width and not 100%.

Thanks for your help