Search
Follow Us
Categories
- Success Stories(157)
Archives
Tag Archives: advanced conditional formatting
Export Excel Data Excluding Hidden Rows in C# using Aspose.Cells for .NET
Aspose.Cells for .NET 8.0.0 has been released. This new release supports optimizing memory use when working with big Microsoft Excel files that have large data sets. When building a workbook with a large data set, or reading a big template file, the total amount of RAM the process will take is always a concern. Aspose.Cells provide measures to cope with this challenge. Aspose.Cells provides relevant options and API calls to lower, reduce and optimize memory usage accordingly. For example, MemorySetting.MemoryPreference … Continue Reading
Read Encrypted Microsoft Excel 2013 Files and Apply Justify Distributed Alignment Setting in Aspose.Cells for Android 5.0.0
We are pleased to announce the release of Aspose.Cells for Android 5.0.0 with new features, enhancements and bug fixes. This new release supports reading password protected Microsoft Excel 2013 files. We provide the Style.setJustifyDistributed() method so you can apply the justify distributed setting while applying text alignment settings on cells.
We also provide support for the B3 (13.9 x 19.7 inches) and Business Card (90 mm x 55 mm) PaperSizeType options.
We have added a number of enhancements and fixes … Continue Reading
Read Encrypted Microsoft Excel 2013 Files, Unhide Rows/Columns to their Original Height/Width and More in Aspose.Cells for Java 7.7.2
We are pleased to announce the release of Aspose.Cells for Java 7.7.2 with new features, enhancements and bug fixes. This new release supports reading password protected Microsoft Excel 2013 files. We provide the Style.setJustifyDistributed() method so you can apply the justify distributed setting while applying text alignment settings on cells.
We also provide support for B3 (13.9 x 19.7 inches) and Business Card (90 mm x 55 mm) PaperSizeType.
We have enhanced the unhiding rows/columns feature in this release. … Continue Reading
Read Encrypted Microsoft Excel 2013 Files, Apply Justify Distributed Alignment Setting and Other Enhancements in Aspose.Cells for .NET 7.7.2
Aspose.Cells for .NET 7.7.2 has been released. This new release supports reading password protected Microsoft Excel 2013 files. We provide the Style.IsJustifyDistributed property so you can apply the justify distributed setting while applying text alignment settings on cells.
We also provide support for B3 (13.9 x 19.7 inches) and Business Card (90 mm x 55 mm) PaperSizeType. We have added the PaperB3 and PaperBusinessCard enumeration members to the PaperSizeType enumeration that can be used when setting page options.
Fixes
… Continue ReadingC# Excel to PDF – Fit All Worksheet Columns onto Single PDF Page
Aspose.Cells for .NET 7.7.0 has been released. This new release supports fitting all worksheet columns on single PDF page. This is a useful feature when you want to generate a PDF file that fits all columns on a worksheet onto a single page. We provide PdfSaveOptions.AllColumnsInOnePagePerSheet property which performs complex calculations, such as the height and width of the resultant PDF page to fit all the columns in.
We also provide a feature for detecting file format type and … Continue Reading
Posted in Aspose.Cells Product Family Tagged Calculate Excel formulas, Embed Ole Objects, Encryption, Excel Files, Fit all worksheet columns in one PDF page, Smart Markers, advanced conditional formatting, export Excel workbooks to PDF, generate password protected Excel files, hide/unhide rows and columns, improved OOXML API, manipulate PivotTables, render MS Excel file formats, render images files from Charts, rendering Charts, select range of cells, web based grid control
Compute Microsoft Excel Selected Color for ColorScale Conditional Formatting using C#
Aspose.Cells for .NET 7.6.1 has been released. This new release supports calculating the color selected by Microsoft Excel when a ColorScale conditional formatting is used in a template file. Moreover, we have enhanced how the product handles encrypted files so that these do not raise FIPS validation errors now. We have also added some significant improvements for the generated password protected files (by Aspose.Cells), so OOXML API does not raise an exception when loading/opening the files in it. Please see … Continue Reading
Posted in Aspose.Cells Product Family Tagged Apply ColorScale Conditional Formatting, Excel Files Encryption, advanced conditional formatting, export Excel workbooks to PDF, generate password protected Excel files, improved OOXML API, manipulate PivotTables, render MS Excel file formats, render images files from Charts, rendering Charts, select range of cells, web based grid control