I can't get sheet tabcolor

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
ykarapinar
Posts: 22
Joined: Fri May 17, 2013 7:59 am

I can't get sheet tabcolor

Post by ykarapinar »

I can't get the sheet tabcolor. It always return the same number (4026531840)

Code: Select all

  XLSReadWriteII51.FileName:='C:\XLSRWII.xlsx';
  XLSReadWriteII51.Read;
  Label1.Font.Color:=XLSReadWriteII51.Sheets[0].TabColor;
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: I can't get sheet tabcolor

Post by larsa »

Hello

Will fix this in the next update.

As a workaround, use this instead:

Code: Select all

Cl := XLS[0].Xc12Sheet.SheetPr.TabColor.ARGB;
Lars Arvidsson, Axolot Data
Post Reply