How to apply filter of first row for 10 columns and how to apply font for particular excelworksheet

GemBox.Spreadsheet
1

How to apply filter of first row for 10 columns and how to apply font for particular excelworksheet

2

i have licenced version of version 37.0 and also how to set font for worksheet

3

Hi Girish,

I’m not exactly sure what you mean by “filter of first row”, nevertheless, I’m afraid that API support for AutoFilter was added in later versions of GemBox.Spreadsheet:

So, you’ll need to renew your license to obtain a new serial key that can be used with the current latest version of GemBox.Spreadsheet. You can contact our sales department for help with that.

Regarding the font, try this:

ExcelFile workbook = ...
workbook.Styles.Normal.Font.Name = "Arial";

I hope this helps.

Regards,
Mario

4 
 Dim ef As ExcelFile = ExcelFile.Load(filePath)
 ef.Styles.Normal.Font.Name = "Arial"

Error: Styles is not member of ExcelFile
version: 37.3.30.1000
Please help here

5

image

i want to apply filter the header row and column are not specific and those are generating dynamically.

version: 37.3.30.1000

6

Hi Girish,

You’ll need to upgrade your GemBox.Spreadsheet license and use the latest version. That old version that you’re currently using doesn’t have the API members that you want.

Again, you can contact our sales department to help you out with that.

Let me know if you need anything else.

Regards,
Mario

7

So , basically it should not work filter and setting font in older version.

8

You can set the font with an older version, but you can’t set the auto filter.

For setting font, you can use the last version of GemBox.Spreadsheet 3.7 (37.3.30.1189):

This version has ExcelFile.Styles property so try using this with it:

ef.Styles("Normal").Font.Name = "Arial"