model

package
v0.0.0-...-f68f8a1 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Aug 27, 2021 License: MIT Imports: 6 Imported by: 0

Documentation

Index

Constants

View Source 
const (
	PICTURETYPE_DIB  = 3
	PICTURETYPE_EMF  = 4
	PICTURETYPE_JPEG = 1
	PICTURETYPE_PICT = 5
	PICTURETYPE_PNG  = 0
	PICTURETYPE_TIFF = 6
	PICTURETYPE_WMF  = 2

	SCOPE_UNDEFINED = -2
	SCOPE_WORKBOOK  = -1

	SHEETTYPE_CHART   = 1
	SHEETTYPE_CHEET   = 0
	SHEETTYPE_UNKNOWN = 2
)
View Source 
const (
	FILTER_VALUE   = 0
	FILTER_TOP10   = 1
	FILTER_CUSTOM  = 2
	FILTER_DYNAMIC = 3
	FILTER_COLOR   = 4
	FILTER_ICON    = 5
	FILTER_EXT     = 6
	FILTER_NOT_SET = 7

	OPERATOR_EQUAL                 = 0
	OPERATOR_GREATER_THAN          = 1
	OPERATOR_GREATER_THAN_OR_EQUAL = 2
	OPERATOR_LESS_THAN             = 3
	OPERATOR_LESS_THAN_OR_EQUAL    = 4
	OPERATOR_NOT_EQUAL             = 5
)
View Source 
const (
	NORMAL      = 0
	SUPERSCRIPT = 1
	SUBSCRIPT   = 2

	UNDERLINE_NONE      = 0
	UNDERLINE_SINGLE    = 1
	UNDERLINE_DOUBLE    = 2
	UNDERLINE_SINGLEACC = 33
	UNDERLINE_DOUBLEACC = 34
)
View Source 
const (
	COLOR_BLACK              = 8
	COLOR_WHITE              = 9
	COLOR_RED                = 10
	COLOR_BRIGHTGREEN        = 11
	COLOR_BLUE               = 12
	COLOR_YELLOW             = 13
	COLOR_PINK               = 14
	COLOR_TURQUOISE          = 15
	COLOR_DARKRED            = 16
	COLOR_GREEN              = 17
	COLOR_DARKBLUE           = 18
	COLOR_DARKYELLOW         = 19
	COLOR_VIOLET             = 20
	COLOR_TEAL               = 21
	COLOR_GRAY25             = 22
	COLOR_GRAY50             = 23
	COLOR_PERIWINKLE_CF      = 24
	COLOR_PLUM_CF            = 25
	COLOR_IVORY_CF           = 26
	COLOR_LIGHTTURQUOISE_CF  = 27
	COLOR_DARKPURPLE_CF      = 28
	COLOR_CORAL_CF           = 29
	COLOR_OCEANBLUE_CF       = 30
	COLOR_ICEBLUE_CF         = 31
	COLOR_DARKBLUE_CL        = 32
	COLOR_PINK_CL            = 33
	COLOR_YELLOW_CL          = 34
	COLOR_TURQUOISE_CL       = 35
	COLOR_VIOLET_CL          = 36
	COLOR_DARKRED_CL         = 37
	COLOR_TEAL_CL            = 38
	COLOR_BLUE_CL            = 39
	COLOR_SKYBLUE            = 40
	COLOR_LIGHTTURQUOISE     = 41
	COLOR_LIGHTGREEN         = 42
	COLOR_LIGHTYELLOW        = 43
	COLOR_PALEBLUE           = 44
	COLOR_ROSE               = 45
	COLOR_LAVENDER           = 46
	COLOR_TAN                = 47
	COLOR_LIGHTBLUE          = 48
	COLOR_AQUA               = 49
	COLOR_LIME               = 50
	COLOR_GOLD               = 51
	COLOR_LIGHTORANGE        = 52
	COLOR_ORANGE             = 53
	COLOR_BLUEGRAY           = 54
	COLOR_GRAY40             = 55
	COLOR_DARKTEAL           = 56
	COLOR_SEAGREEN           = 57
	COLOR_DARKGREEN          = 58
	COLOR_OLIVEGREEN         = 59
	COLOR_BROWN              = 60
	COLOR_PLUM               = 61
	COLOR_INDIGO             = 62
	COLOR_GRAY80             = 63
	COLOR_DEFAULT_FOREGROUND = 64
	COLOR_DEFAULT_BACKGROUND = 65

	AS_DATE           = 1
	AS_FORMULA        = 2
	AS_NUMERIC_STRING = 3

	NUMFORMAT_GENERAL                 = 0
	NUMFORMAT_NUMBER                  = 1
	NUMFORMAT_NUMBER_D2               = 2
	NUMFORMAT_NUMBER_SEP              = 3
	NUMFORMAT_NUMBER_SEP_D2           = 4
	NUMFORMAT_CURRENCY_NEGBRA         = 5
	NUMFORMAT_CURRENCY_NEGBRARED      = 6
	NUMFORMAT_CURRENCY_D2_NEGBRA      = 7
	NUMFORMAT_CURRENCY_D2_NEGBRARED   = 8
	NUMFORMAT_PERCENT                 = 9
	NUMFORMAT_PERCENT_D2              = 10
	NUMFORMAT_SCIENTIFIC_D2           = 11
	NUMFORMAT_FRACTION_ONEDIG         = 12
	NUMFORMAT_FRACTION_TWODIG         = 13
	NUMFORMAT_DATE                    = 14
	NUMFORMAT_CUSTOM_DMON_YY          = 15
	NUMFORMAT_CUSTOM_DMON             = 16
	NUMFORMAT_CUSTOM_MON_YY           = 17
	NUMFORMAT_CUSTOM_HMM_AM           = 18
	NUMFORMAT_CUSTOM_HMMSS_AM         = 19
	NUMFORMAT_CUSTOM_HMM              = 20
	NUMFORMAT_CUSTOM_HMMSS            = 21
	NUMFORMAT_CUSTOM_MDYYYY_HMM       = 22
	NUMFORMAT_NUMBER_SEP_NEGBRA       = 37
	NUMFORMAT_NUMBER_SEP_NEGBRARED    = 38
	NUMFORMAT_NUMBER_D2_SEP_NEGBRA    = 39
	NUMFORMAT_NUMBER_D2_SEP_NEGBRARED = 40
	NUMFORMAT_ACCOUNT                 = 41
	NUMFORMAT_ACCOUNTCUR              = 42
	NUMFORMAT_ACCOUNT_D2              = 43
	NUMFORMAT_ACCOUNT_D2_CUR          = 44
	NUMFORMAT_CUSTOM_MMSS             = 45
	NUMFORMAT_CUSTOM_H0MMSS           = 46
	NUMFORMAT_CUSTOM_MMSS0            = 47
	NUMFORMAT_CUSTOM000P0E_PLUS0      = 48
	NUMFORMAT_TEXT                    = 49

	ALIGNH_GENERAL     = 0
	ALIGNH_LEFT        = 1
	ALIGNH_CENTER      = 2
	ALIGNH_RIGHT       = 3
	ALIGNH_FILL        = 4
	ALIGNH_JUSTIFY     = 5
	ALIGNH_MERGE       = 6
	ALIGNH_DISTRIBUTED = 7

	ALIGNV_TOP         = 0
	ALIGNV_CENTER      = 1
	ALIGNV_BOTTOM      = 2
	ALIGNV_JUSTIFY     = 3
	ALIGNV_DISTRIBUTED = 4

	BORDERSTYLE_NONE             = 0
	BORDERSTYLE_THIN             = 1
	BORDERSTYLE_MEDIUM           = 2
	BORDERSTYLE_DASHED           = 3
	BORDERSTYLE_DOTTED           = 4
	BORDERSTYLE_THICK            = 5
	BORDERSTYLE_DOUBLE           = 6
	BORDERSTYLE_HAIR             = 7
	BORDERSTYLE_MEDIUMDASHED     = 8
	BORDERSTYLE_DASHDOT          = 9
	BORDERSTYLE_MEDIUMDASHDOT    = 10
	BORDERSTYLE_DASHDOTDOT       = 11
	BORDERSTYLE_MEDIUMDASHDOTDOT = 12
	BORDERSTYLE_SLANTDASHDOT     = 13
	BORDERDIAGONAL_NONE          = 0
	BORDERDIAGONAL_DOWN          = 1
	BORDERDIAGONAL_UP            = 2
	BORDERDIAGONAL_BOTH          = 3

	FILLPATTERN_NONE                = 0
	FILLPATTERN_SOLID               = 1
	FILLPATTERN_GRAY50              = 2
	FILLPATTERN_GRAY75              = 3
	FILLPATTERN_GRAY25              = 4
	FILLPATTERN_HORSTRIPE           = 5
	FILLPATTERN_VERSTRIPE           = 6
	FILLPATTERN_REVDIAGSTRIPE       = 7
	FILLPATTERN_DIAGSTRIPE          = 8
	FILLPATTERN_DIAGCROSSHATCH      = 9
	FILLPATTERN_THICKDIAGCROSSHATCH = 10
	FILLPATTERN_THINHORSTRIPE       = 11
	FILLPATTERN_THINVERSTRIPE       = 12
	FILLPATTERN_THINREVDIAGSTRIPE   = 13
	FILLPATTERN_THINDIAGSTRIPE      = 14
	FILLPATTERN_THINHORCROSSHATCH   = 15
	FILLPATTERN_THINDIAGCROSSHATCH  = 16
	FILLPATTERN_GRAY12P5            = 17
	FILLPATTERN_GRAY6P25            = 18
)
View Source 
const (
	PAPER_DEFAULT              = 0
	PAPER_LETTER               = 1
	PAPER_LETTERSMALL          = 2
	PAPER_TABLOID              = 3
	PAPER_LEDGER               = 4
	PAPER_LEGAL                = 5
	PAPER_STATEMENT            = 6
	PAPER_EXECUTIVE            = 7
	PAPER_A3                   = 8
	PAPER_A4                   = 9
	PAPER_A4SMALL              = 10
	PAPER_A5                   = 11
	PAPER_B4                   = 12
	PAPER_B5                   = 13
	PAPER_FOLIO                = 14
	PAPER_QUATRO               = 15
	PAPER10X14                 = 16
	PAPER10X17                 = 17
	PAPER_NOTE                 = 18
	PAPER_ENVELOPE9            = 19
	PAPER_ENVELOPE10           = 20
	PAPER_ENVELOPE11           = 21
	PAPER_ENVELOPE12           = 22
	PAPER_ENVELOPE14           = 23
	PAPER_CSIZE                = 24
	PAPER_DSIZE                = 25
	PAPER_ESIZE                = 26
	PAPER_ENVELOPE_DL          = 27
	PAPER_ENVELOPE_C5          = 28
	PAPER_ENVELOPE_C3          = 29
	PAPER_ENVELOPE_C4          = 30
	PAPER_ENVELOPE_C6          = 31
	PAPER_ENVELOPE_C65         = 32
	PAPER_ENVELOPE_B4          = 33
	PAPER_ENVELOPE_B5          = 34
	PAPER_ENVELOPE_B6          = 35
	PAPER_ENVELOPE             = 36
	PAPER_ENVELOPE_MONARCH     = 37
	PAPER_US_ENVELOPE          = 38
	PAPER_FANFOLD              = 39
	PAPER_GERMAN_STD_FANFOLD   = 40
	PAPER_GERMAN_LEGAL_FANFOLD = 41

	CELLTYPE_EMPTY   = 0
	CELLTYPE_NUMBER  = 1
	CELLTYPE_STRING  = 2
	CELLTYPE_BOOLEAN = 3
	CELLTYPE_BLANK   = 4
	CELLTYPE_ERROR   = 5

	ERRORTYPE_NULL    = 0
	ERRORTYPE_DIV0    = 7
	ERRORTYPE_VALUE   = 15
	ERRORTYPE_REF     = 23
	ERRORTYPE_NAME    = 29
	ERRORTYPE_NUM     = 36
	ERRORTYPE_NA      = 42
	ERRORTYPE_NOERROR = 255

	LEFT_TO_RIGHT = 0
	RIGHT_TO_LEFT = 1

	IERR_EVAL_ERROR            = 1
	IERR_EMPTY_CELLREF         = 2
	IERR_NUMBER_STORED_AS_TEXT = 4
	IERR_INCONSIST_RANGE       = 8
	IERR_INCONSIST_FMLA        = 16
	IERR_TWODIG_TEXTYEAR       = 32
	IERR_UNLOCK_FMLA           = 64
	IERR_DATA_VALIDATION       = 128

	PROT_DEFAULT            = -1
	PROT_ALL                = 0
	PROT_OBJECTS            = 1
	PROT_SCENARIOS          = 2
	PROT_FORMAT_CELLS       = 4
	PROT_FORMAT_COLUMNS     = 8
	PROT_FORMAT_ROWS        = 16
	PROT_INSERT_COLUMNS     = 32
	PROT_INSERT_ROWS        = 64
	PROT_INSERT_HYPERLINKS  = 128
	PROT_DELETE_COLUMNS     = 256
	PROT_DELETE_ROWS        = 512
	PROT_SEL_LOCKED_CELLS   = 1024
	PROT_SORT               = 2048
	PROT_AUTOFILTER         = 4096
	PROT_PIVOTTABLES        = 8192
	PROT_SEL_UNLOCKED_CELLS = 16384

	SHEETSTATE_VISIBLE    = 0
	SHEETSTATE_HIDDEN     = 1
	SHEETSTATE_VERYHIDDEN = 2

	VALIDATION_TYPE_NONE             = 0
	VALIDATION_TYPE_WHOLE            = 1
	VALIDATION_TYPE_DECIMAL          = 2
	VALIDATION_TYPE_LIST             = 3
	VALIDATION_TYPE_DATE             = 4
	VALIDATION_TYPE_TIME             = 5
	VALIDATION_TYPE_TEXTLENGTH       = 6
	VALIDATION_TYPE_CUSTOM           = 7
	VALIDATION_OP_BETWEEN            = 0
	VALIDATION_OP_NOTBETWEEN         = 1
	VALIDATION_OP_EQUAL              = 2
	VALIDATION_OP_NOTEQUAL           = 3
	VALIDATION_OP_LESSTHAN           = 4
	VALIDATION_OP_LESSTHANOREQUAL    = 5
	VALIDATION_OP_GREATERTHAN        = 6
	VALIDATION_OP_GREATERTHANOREQUAL = 7
	VALIDATION_ERRSTYLE_STOP         = 0 // STOP ICON IN THE ERROR ALERT
	VALIDATION_ERRSTYLE_WARNING      = 1 // WARNING ICON IN THE ERROR ALERT
	VALIDATION_ERRSTYLE_INFORMATION  = 2 // INFORMATION ICON IN THE ERROR ALERT
)

Variables

This section is empty.

Functions

func F 

func F(number float64) uintptr

func F_P 

func F_P(number *float64) uintptr

func I 

func I(number int) uintptr

func I_P 

func I_P(number *int) uintptr

func S 

func S(text string) uintptr

func S_P 

func S_P(text *string) uintptr

Types

type AutoFilter 

type AutoFilter struct {
	// contains filtered or unexported fields
}

func (*AutoFilter) Column 

func (xa *AutoFilter) Column(colId int) *FilterColumn

FilterColumnHandle xlAutoFilterColumnW(AutoFilterHandle handle, int colId);

func (*AutoFilter) ColumnByIndex 

func (xa *AutoFilter) ColumnByIndex(index int) *FilterColumn

FilterColumnHandle xlAutoFilterColumnByIndexW(AutoFilterHandle handle, int index);

func (*AutoFilter) ColumnSize 

func (xa *AutoFilter) ColumnSize() int

int xlAutoFilterColumnSizeW(AutoFilterHandle handle);

func (*AutoFilter) GetRef 

func (xa *AutoFilter) GetRef() (rowFirst int, rowLast int, colFirst int, colLast int)

int xlAutoFilterGetRefW(AutoFilterHandle handle, int* rowFirst, int* rowLast, int* colFirst, int* colLast);

func (*AutoFilter) GetSelf 

func (xa *AutoFilter) GetSelf() uintptr

func (*AutoFilter) GetSort 

func (xa *AutoFilter) GetSort() (columnIndex int, descending int)

int xlAutoFilterGetSortW(AutoFilterHandle handle, int* columnIndex, int* descending);

func (*AutoFilter) GetSortRange 

func (xa *AutoFilter) GetSortRange() (rowFirst int, rowLast int, colFirst int, colLast int)

int xlAutoFilterGetSortRangeW(AutoFilterHandle handle, int* rowFirst, int* rowLast, int* colFirst, int* colLast);

func (*AutoFilter) SetRef 

func (xa *AutoFilter) SetRef(rowFirst int, rowLast int, colFirst int, colLast int)

void xlAutoFilterSetRefW(AutoFilterHandle handle, int rowFirst, int rowLast, int colFirst, int colLast);

func (*AutoFilter) SetSort 

func (xa *AutoFilter) SetSort(columnIndex int, descending int) int

int xlAutoFilterSetSortW(AutoFilterHandle handle, int columnIndex, int descending);

type Book 

type Book struct {
	// contains filtered or unexported fields
}

func (*Book) ActiveSheet 

func (xb *Book) ActiveSheet() int

int xlBookActiveSheetW(BookHandle handle);

func (*Book) AddCustomNumFormat 

func (xb *Book) AddCustomNumFormat(customNumFormat string) int

int xlBookAddCustomNumFormatW(BookHandle handle, const wchar_t* customNumFormat);

func (*Book) AddFont 

func (xb *Book) AddFont() *Font

FontHandle xlBookAddFontW(BookHandle handle, FontHandle initFont);

func (*Book) AddFormat 

func (xb *Book) AddFormat() *Format

FormatHandle xlBookAddFormatW(BookHandle handle, FormatHandle initFormat);

func (*Book) AddPicture 

func (xb *Book) AddPicture(filename string) int

int xlBookAddPictureW(BookHandle handle, const wchar_t* filename);

func (*Book) AddPicture2 

func (xb *Book) AddPicture2(data string) int

int xlBookAddPicture2W(BookHandle handle, const char* data, unsigned size); 

func (xb *Book) AddPictureAsLink(filename string, insert int) int

int xlBookAddPictureAsLinkW(BookHandle handle, const wchar_t* filename, int insert);

func (*Book) AddSheet 

func (xb *Book) AddSheet(name string, initSheet *Sheet) *Sheet

SheetHandle xlBookAddSheetW(BookHandle handle, const wchar_t* name, SheetHandle initSheet);

func (*Book) BiffVersion 

func (xb *Book) BiffVersion() int

int xlBookBiffVersionW(BookHandle handle);

func (*Book) ColorPack 

func (xb *Book) ColorPack(red int, green int, blue int) int

int xlBookColorPackW(BookHandle handle, int red, int green, int blue);

func (*Book) ColorUnpack 

func (xb *Book) ColorUnpack(color int) (red int, green int, blue int)

void xlBookColorUnpackW(BookHandle handle, int color, int* red, int* green, int* blue);

func (*Book) CreateXLS 

func (xb *Book) CreateXLS(libxlDllFilePath string)

func (*Book) CreateXLSX 

func (xb *Book) CreateXLSX(libxlDllFilePath string)

func (*Book) CustomNumFormat 

func (xb *Book) CustomNumFormat(fmt int) string

string xlBookCustomNumFormatW(BookHandle handle, int fmt);

func (*Book) DatePack 

func (xb *Book) DatePack(year int, month int, day int, hour int, min int, sec int, msec int) float64

double xlBookDatePackW(BookHandle handle, int year, int month, int day, int hour, int min, int sec, int msec);

func (*Book) DateUnpack 

func (xb *Book) DateUnpack(value float64, year int, month int, day int, hour int, min int, sec int, msec int) int

int xlBookDateUnpackW(BookHandle handle, double value, int* year, int* month, int* day, int* hour, int* min, int* sec, int* msec);

func (*Book) DefaultFont 

func (xb *Book) DefaultFont() (fontName string, fontSize int)

string xlBookDefaultFontW(BookHandle handle, int* fontSize);

func (*Book) DelSheet 

func (xb *Book) DelSheet(index int) int

int xlBookDelSheetW(BookHandle handle, int index);

func (*Book) ErrorMessage 

func (xb *Book) ErrorMessage() string

string xlBookErrorMessageW(BookHandle handle);

func (*Book) Font 

func (xb *Book) Font(index int) *Font

FontHandle xlBookFontW(BookHandle handle, int index);

func (*Book) FontSize 

func (xb *Book) FontSize() int

int xlBookFontSizeW(BookHandle handle);

func (*Book) Format 

func (xb *Book) Format(index int) *Format

FormatHandle xlBookFormatW(BookHandle handle, int index);

func (*Book) FormatSize 

func (xb *Book) FormatSize() int

int xlBookFormatSizeW(BookHandle handle);

func (*Book) GetPicture 

func (xb *Book) GetPicture(index int) string

int xlBookGetPictureW(BookHandle handle, int index, const char** data, unsigned* size);

func (*Book) GetSelf 

func (xb *Book) GetSelf() uintptr

func (*Book) GetSheet 

func (xb *Book) GetSheet(index int) *Sheet

SheetHandle xlBookGetSheetW(BookHandle handle, int index);

func (*Book) GetSheetName 

func (xb *Book) GetSheetName(index int) string

const wchar_t* xlBookGetSheetName(BookHandle handle, int index)

func (*Book) InsertSheet 

func (xb *Book) InsertSheet(index int, name string, initSheet *Sheet) *Sheet

SheetHandle xlBookInsertSheetW(BookHandle handle, int index, const wchar_t* name, SheetHandle initSheet);

func (*Book) IsDate1904 

func (xb *Book) IsDate1904() int

int xlBookIsDate1904W(BookHandle handle);

func (*Book) IsTemplate 

func (xb *Book) IsTemplate() int

int xlBookIsTemplateW(BookHandle handle);

func (*Book) Load 

func (xb *Book) Load(filename string) int

int xlBookLoadW(BookHandle handle, const wchar_t* filename);

func (*Book) LoadInfo 

func (xb *Book) LoadInfo(filename string) int

int xlBookLoadInfo(BookHandle handle, const wchar_t* filename)

func (*Book) LoadPartially 

func (xb *Book) LoadPartially(filename string, sheetIndex int, firstRow int, lastRow int) int

int xlBookLoadPartiallyW(BookHandle handle, const wchar_t* filename, int sheetIndex, int firstRow, int lastRow);

func (*Book) LoadPartiallyUsingTempFile 

func (xb *Book) LoadPartiallyUsingTempFile(filename string, sheetIndex int, firstRow int, lastRow int, tempFile string) int

int xlBookLoadPartiallyUsingTempFileW(BookHandle handle, const wchar_t* filename, int sheetIndex, int firstRow, int lastRow, const wchar_t* tempFile);

func (*Book) LoadRaw 

func (xb *Book) LoadRaw(data string, size int) int

int xlBookLoadRawW(BookHandle handle, const char* data, unsigned size);

func (*Book) LoadRawPartially 

func (xb *Book) LoadRawPartially(data string, size int, sheetIndex int, firstRow int, lastRow int) int

int xlBookLoadRawPartiallyW(BookHandle handle, const char* data, unsigned size, int sheetIndex, int firstRow, int lastRow);

func (*Book) LoadUsingTempFile 

func (xb *Book) LoadUsingTempFile(filename string, tempFile string) int

int xlBookLoadUsingTempFileW(BookHandle handle, const wchar_t* filename, const wchar_t* tempFile);

func (*Book) LoadWithoutEmptyCells 

func (xb *Book) LoadWithoutEmptyCells(filename string) int

int xlBookLoadWithoutEmptyCellsW(BookHandle handle, const wchar_t* filename);

func (*Book) MoveSheet 

func (xb *Book) MoveSheet(srcIndex int, dstIndex int) int

int xlBookMoveSheetW(BookHandle handle, int srcIndex, int dstIndex);

func (*Book) PictureSize 

func (xb *Book) PictureSize() int

int xlBookPictureSizeW(BookHandle handle);

func (*Book) RefR1C1 

func (xb *Book) RefR1C1() int

int xlBookRefR1C1W(BookHandle handle);

func (*Book) Release 

func (xb *Book) Release()

void xlBookReleaseW(BookHandle handle);

func (*Book) RgbMode 

func (xb *Book) RgbMode() int

int xlBookRgbModeW(BookHandle handle);

func (*Book) Save 

func (xb *Book) Save(filename string) int

int xlBookSaveW(BookHandle handle, const wchar_t* filename);

func (*Book) SaveRaw 

func (xb *Book) SaveRaw() string

int xlBookSaveRawW(BookHandle handle, const char** data, unsigned* size); @deprecated

func (*Book) SaveUsingTempFile 

func (xb *Book) SaveUsingTempFile(filename string, useTempFile int) int

int xlBookSaveUsingTempFileW(BookHandle handle, const wchar_t* filename, int useTempFile);

func (*Book) SetActiveSheet 

func (xb *Book) SetActiveSheet(index int)

void xlBookSetActiveSheetW(BookHandle handle, int index);

func (*Book) SetDate1904 

func (xb *Book) SetDate1904(date1904 int)

void xlBookSetDate1904W(BookHandle handle, int date1904);

func (*Book) SetDefaultFont 

func (xb *Book) SetDefaultFont(fontName string, fontSize int)

void xlBookSetDefaultFontW(BookHandle handle, const wchar_t* fontName, int fontSize);

func (*Book) SetKey 

func (xb *Book) SetKey(name string, key string)

void xlBookSetKeyW(BookHandle handle, const wchar_t* name, const wchar_t* key);

func (*Book) SetLocale 

func (xb *Book) SetLocale(locale string) int

int xlBookSetLocaleW(BookHandle handle, const char* locale);

func (*Book) SetRefR1C1 

func (xb *Book) SetRefR1C1(refR1C1 int)

void xlBookSetRefR1C1W(BookHandle handle, int refR1C1);

func (*Book) SetRgbMode 

func (xb *Book) SetRgbMode(rgbMode int)

void xlBookSetRgbModeW(BookHandle handle, int rgbMode);

func (*Book) SetTemplate 

func (xb *Book) SetTemplate(tmpl int)

void xlBookSetTemplateW(BookHandle handle, int tmpl);

func (*Book) SheetCount 

func (xb *Book) SheetCount() int

int xlBookSheetCountW(BookHandle handle);

func (*Book) SheetType 

func (xb *Book) SheetType(index int) int

int xlBookSheetTypeW(BookHandle handle, int index);

func (*Book) Version 

func (xb *Book) Version() int

int xlBookVersionW(BookHandle handle);

type FilterColumn 

type FilterColumn struct {
	// contains filtered or unexported fields
}

func (*FilterColumn) AddFilter 

func (xf *FilterColumn) AddFilter(value string)

void xlFilterColumnAddFilterW(FilterColumnHandle handle, const wchar_t* value);

func (*FilterColumn) Clear 

func (xf *FilterColumn) Clear()

void xlFilterColumnClearW(FilterColumnHandle handle);

func (*FilterColumn) Filter 

func (xf *FilterColumn) Filter(index int) string

string xlFilterColumnFilterW(FilterColumnHandle handle, int index);

func (*FilterColumn) FilterSize 

func (xf *FilterColumn) FilterSize() int

int xlFilterColumnFilterSizeW(FilterColumnHandle handle);

func (*FilterColumn) FilterType 

func (xf *FilterColumn) FilterType() int

int xlFilterColumnFilterTypeW(FilterColumnHandle handle);

func (*FilterColumn) GetCustomFilter 

func (xf *FilterColumn) GetCustomFilter() (op1 int, v1 string, op2 int, v2 string, andOp int)

int xlFilterColumnGetCustomFilterW(FilterColumnHandle handle, int* op1, const wchar_t** v1, int* op2, const wchar_t** v2, int* andOp);

func (*FilterColumn) GetSelf 

func (xf *FilterColumn) GetSelf() uintptr

func (*FilterColumn) GetTop10 

func (xf *FilterColumn) GetTop10() (value float64, top int, percent int)

int xlFilterColumnGetTop10W(FilterColumnHandle handle, double* value, int* top, int* percent);

func (*FilterColumn) Index 

func (xf *FilterColumn) Index() int

int xlFilterColumnIndexW(FilterColumnHandle handle);

func (*FilterColumn) SetCustomFilter 

func (xf *FilterColumn) SetCustomFilter(op int, val string)

void xlFilterColumnSetCustomFilterW(FilterColumnHandle handle, int op, const wchar_t* val);

func (*FilterColumn) SetCustomFilterEx 

func (xf *FilterColumn) SetCustomFilterEx(op1 int, v1 string, op2 int, v2 string, andOp int)

void xlFilterColumnSetCustomFilterExW(FilterColumnHandle handle, int op1, const wchar_t* v1, int op2, const wchar_t* v2, int andOp);

func (*FilterColumn) SetTop10 

func (xf *FilterColumn) SetTop10(value float64, top int, percent int)

void xlFilterColumnSetTop10W(FilterColumnHandle handle, double value, int top, int percent);

type Font 

type Font struct {
	// contains filtered or unexported fields
}

func (*Font) Bold 

func (xf *Font) Bold() int

int xlFontBoldW(FontHandle handle);

func (*Font) Color 

func (xf *Font) Color() int

int xlFontColorW(FontHandle handle);

func (*Font) FontName 

func (xf *Font) FontName(underline int) string

string xlFontNameW(FontHandle handle);

func (*Font) Italic 

func (xf *Font) Italic() int

int xlFontItalicW(FontHandle handle);

func (*Font) Script 

func (xf *Font) Script() int

int xlFontScriptW(FontHandle handle);

func (*Font) SetBold 

func (xf *Font) SetBold(bold int)

void xlFontSetBoldW(FontHandle handle, int bold);

func (*Font) SetColor 

func (xf *Font) SetColor(color int)

void xlFontSetColorW(FontHandle handle, int color);

func (*Font) SetItalic 

func (xf *Font) SetItalic(italic int)

void xlFontSetItalicW(FontHandle handle, int italic);

func (*Font) SetName 

func (xf *Font) SetName(name string)

void xlFontSetNameW(FontHandle handle, const wchar_t* name);

func (*Font) SetScript 

func (xf *Font) SetScript(script int)

void xlFontSetScriptW(FontHandle handle, int script);

func (*Font) SetSize 

func (xf *Font) SetSize(size int)

void xlFontSetSizeW(FontHandle handle, int size);

func (*Font) SetStrikeOut 

func (xf *Font) SetStrikeOut(strikeOut int)

void xlFontSetStrikeOutW(FontHandle handle, int strikeOut);

func (*Font) SetUnderline 

func (xf *Font) SetUnderline(underline int)

void xlFontSetUnderlineW(FontHandle handle, int underline);

func (*Font) Size 

func (xf *Font) Size() int

int xlFontSizeW(FontHandle handle);

func (*Font) StrikeOut 

func (xf *Font) StrikeOut() int

int xlFontStrikeOutW(FontHandle handle);

func (*Font) Underline 

func (xf *Font) Underline() int

int xlFontUnderlineW(FontHandle handle);

type Format 

type Format struct {
	// contains filtered or unexported fields
}

func (*Format) AlignH 

func (xf *Format) AlignH() int

int xlFormatAlignHW(FormatHandle handle);

func (*Format) AlignV 

func (xf *Format) AlignV() int

int xlFormatAlignVW(FormatHandle handle);

func (*Format) BorderBottom 

func (xf *Format) BorderBottom() int

int xlFormatBorderBottomW(FormatHandle handle);

func (*Format) BorderBottomColor 

func (xf *Format) BorderBottomColor() int

int xlFormatBorderBottomColorW(FormatHandle handle);

func (*Format) BorderDiagonal 

func (xf *Format) BorderDiagonal() int

int xlFormatBorderDiagonalW(FormatHandle handle);

func (*Format) BorderDiagonalColor 

func (xf *Format) BorderDiagonalColor() int

int xlFormatBorderDiagonalColorW(FormatHandle handle);

func (*Format) BorderDiagonalStyle 

func (xf *Format) BorderDiagonalStyle() int

int xlFormatBorderDiagonalStyleW(FormatHandle handle);

func (*Format) BorderLeft 

func (xf *Format) BorderLeft() int

int xlFormatBorderLeftW(FormatHandle handle);

func (*Format) BorderLeftColor 

func (xf *Format) BorderLeftColor() int

int xlFormatBorderLeftColorW(FormatHandle handle);

func (*Format) BorderRight 

func (xf *Format) BorderRight() int

int xlFormatBorderRightW(FormatHandle handle);

func (*Format) BorderRightColor 

func (xf *Format) BorderRightColor() int

int xlFormatBorderRightColorW(FormatHandle handle);

func (*Format) BorderTop 

func (xf *Format) BorderTop() int

int xlFormatBorderTopW(FormatHandle handle);

func (*Format) BorderTopColor 

func (xf *Format) BorderTopColor() int

int xlFormatBorderTopColorW(FormatHandle handle);

func (*Format) FillPattern 

func (xf *Format) FillPattern() int

int xlFormatFillPatternW(FormatHandle handle);

func (*Format) Font 

func (xf *Format) Font() *Font

FontHandle xlFormatFontW(FormatHandle handle);

func (*Format) GetBook 

func (xf *Format) GetBook() uintptr

func (*Format) GetSelf 

func (xf *Format) GetSelf() uintptr

func (*Format) Hidden 

func (xf *Format) Hidden() int

int xlFormatHiddenW(FormatHandle handle);

func (*Format) Indent 

func (xf *Format) Indent() int

int xlFormatIndentW(FormatHandle handle);

func (*Format) Locked 

func (xf *Format) Locked() int

int xlFormatLockedW(FormatHandle handle);

func (*Format) NumFormat 

func (xf *Format) NumFormat() int

int xlFormatNumFormatW(FormatHandle handle);

func (*Format) PatternBackgroundColor 

func (xf *Format) PatternBackgroundColor() int

int xlFormatPatternBackgroundColorW(FormatHandle handle);

func (*Format) PatternForegroundColor 

func (xf *Format) PatternForegroundColor() int

int xlFormatPatternForegroundColorW(FormatHandle handle);

func (*Format) Rotation 

func (xf *Format) Rotation() int

int xlFormatRotationW(FormatHandle handle);

func (*Format) SetAlignH 

func (xf *Format) SetAlignH(align int)

void xlFormatSetAlignHW(FormatHandle handle, int align);

func (*Format) SetAlignV 

func (xf *Format) SetAlignV(align int)

void xlFormatSetAlignVW(FormatHandle handle, int align);

func (*Format) SetBorder 

func (xf *Format) SetBorder(style int)

void xlFormatSetBorderW(FormatHandle handle, int style);

func (*Format) SetBorderBottom 

func (xf *Format) SetBorderBottom(style int)

void xlFormatSetBorderBottomW(FormatHandle handle, int style);

func (*Format) SetBorderBottomColor 

func (xf *Format) SetBorderBottomColor(color int)

void xlFormatSetBorderBottomColorW(FormatHandle handle, int color);

func (*Format) SetBorderColor 

func (xf *Format) SetBorderColor(color int)

void xlFormatSetBorderColorW(FormatHandle handle, int color);

func (*Format) SetBorderDiagonal 

func (xf *Format) SetBorderDiagonal(border int)

void xlFormatSetBorderDiagonalW(FormatHandle handle, int border);

func (*Format) SetBorderDiagonalColor 

func (xf *Format) SetBorderDiagonalColor(color int)

void xlFormatSetBorderDiagonalColorW(FormatHandle handle, int color);

func (*Format) SetBorderDiagonalStyle 

func (xf *Format) SetBorderDiagonalStyle(style int)

void xlFormatSetBorderDiagonalStyleW(FormatHandle handle, int style);

func (*Format) SetBorderLeft 

func (xf *Format) SetBorderLeft(style int)

void xlFormatSetBorderLeftW(FormatHandle handle, int style);

func (*Format) SetBorderLeftColor 

func (xf *Format) SetBorderLeftColor(color int)

void xlFormatSetBorderLeftColorW(FormatHandle handle, int color);

func (*Format) SetBorderRight 

func (xf *Format) SetBorderRight(style int)

void xlFormatSetBorderRightW(FormatHandle handle, int style);

func (*Format) SetBorderRightColor 

func (xf *Format) SetBorderRightColor(color int)

void xlFormatSetBorderRightColorW(FormatHandle handle, int color);

func (*Format) SetBorderTop 

func (xf *Format) SetBorderTop(style int)

void xlFormatSetBorderTopW(FormatHandle handle, int style);

func (*Format) SetBorderTopColor 

func (xf *Format) SetBorderTopColor(color int)

void xlFormatSetBorderTopColorW(FormatHandle handle, int color);

func (*Format) SetFillPattern 

func (xf *Format) SetFillPattern(pattern int)

void xlFormatSetFillPatternW(FormatHandle handle, int pattern);

func (*Format) SetFont 

func (xf *Format) SetFont(fontHandle *Font) int

int xlFormatSetFontW(FormatHandle handle, FontHandle fontHandle);

func (*Format) SetHidden 

func (xf *Format) SetHidden(hidden int)

void xlFormatSetHiddenW(FormatHandle handle, int hidden);

func (*Format) SetIndent 

func (xf *Format) SetIndent(indent int)

void xlFormatSetIndentW(FormatHandle handle, int indent);

func (*Format) SetLocked 

func (xf *Format) SetLocked(locked int)

void xlFormatSetLockedW(FormatHandle handle, int locked);

func (*Format) SetNumFormat 

func (xf *Format) SetNumFormat(numFormat int)

void xlFormatSetNumFormatW(FormatHandle handle, int numFormat);

func (*Format) SetPatternBackgroundColor 

func (xf *Format) SetPatternBackgroundColor(color int)

void xlFormatSetPatternBackgroundColorW(FormatHandle handle, int color);

func (*Format) SetPatternForegroundColor 

func (xf *Format) SetPatternForegroundColor(color int)

void xlFormatSetPatternForegroundColorW(FormatHandle handle, int color);

func (*Format) SetRotation 

func (xf *Format) SetRotation(rotation int) int

int xlFormatSetRotationW(FormatHandle handle, int rotation);

func (*Format) SetShrinkToFit 

func (xf *Format) SetShrinkToFit(shrinkToFit int)

void xlFormatSetShrinkToFitW(FormatHandle handle, int shrinkToFit);

func (*Format) SetWrap 

func (xf *Format) SetWrap(wrap int)

void xlFormatSetWrapW(FormatHandle handle, int wrap);

func (*Format) ShrinkToFit 

func (xf *Format) ShrinkToFit() int

int xlFormatShrinkToFitW(FormatHandle handle);

func (*Format) Wrap 

func (xf *Format) Wrap() int

int xlFormatWrapW(FormatHandle handle);

type Sheet 

type Sheet struct {
	// contains filtered or unexported fields
}

func (*Sheet) AddDataValidation 

func (xs *Sheet) AddDataValidation(typ int, op int, rowFirst int, rowLast int, colFirst int, colLast int, value1 string, value2 string)

void xlSheetAddDataValidationW(SheetHandle handle, int type, int op, int rowFirst, int rowLast, int colFirst, int colLast, const wchar_t* value1, const wchar_t* value2);

func (*Sheet) AddDataValidationDouble 

func (xs *Sheet) AddDataValidationDouble(typ int, op int, rowFirst int, rowLast int, colFirst int, colLast int, value1 float64, value2 float64)

void xlSheetAddDataValidationDoubleW(SheetHandle handle, int type, int op, int rowFirst, int rowLast, int colFirst, int colLast, double value1, double value2);

func (*Sheet) AddDataValidationDoubleEx 

func (xs *Sheet) AddDataValidationDoubleEx(vtype int, op int, rowFirst int, rowLast int, colFirst int, colLast int, value1 float64, value2 float64,
	allowBlank int, hideDropDown int, showInputMessage int, showErrorMessage int, promptTitle string, prompt string,
	errorTitle string, error string, errorStyle int)

void xlSheetAddDataValidationDoubleExW(SheetHandle handle, int type, int op, int rowFirst, int rowLast, int colFirst, int colLast, double value1, double value2, 

	int allowBlank, int hideDropDown, int showInputMessage, int showErrorMessage, const wchar_t* promptTitle, const wchar_t* prompt,
    const wchar_t* errorTitle, const wchar_t* error, int errorStyle);

func (*Sheet) AddDataValidationEx 

func (xs *Sheet) AddDataValidationEx(vtype int, op int, rowFirst int, rowLast int, colFirst int, colLast int, value1 string, value2 string,
	allowBlank int, hideDropDown int, showInputMessage int, showErrorMessage int, promptTitle string, prompt string,
	errorTitle string, error string, errorStyle int)

void xlSheetAddDataValidationExW(SheetHandle handle, int type, int op, int rowFirst, int rowLast, int colFirst, int colLast, const wchar_t* value1, const wchar_t* value2, 

int allowBlank, int hideDropDown, int showInputMessage, int showErrorMessage, const wchar_t* promptTitle, const wchar_t* prompt,
const wchar_t* errorTitle, const wchar_t* error, int errorStyle);

func (xs *Sheet) AddHyperlink(hyperlink string, rowFirst int, rowLast int, colFirst int, colLast int)

void xlSheetAddHyperlinkW(SheetHandle handle, const wchar_t* hyperlink, int rowFirst, int rowLast, int colFirst, int colLast);

func (*Sheet) AddIgnoredError 

func (xs *Sheet) AddIgnoredError(rowFirst int, colFirst int, rowLast int, colLast int, iError int) int

int xlSheetAddIgnoredErrorW(SheetHandle handle, int rowFirst, int colFirst, int rowLast, int colLast, int iError);

func (*Sheet) AddrToRowCol 

func (xs *Sheet) AddrToRowCol(addr string) (row int, col int, rowRelative int, colRelative int)

void xlSheetAddrToRowColW(SheetHandle handle, const wchar_t* addr, int* row, int* col, int* rowRelative, int* colRelative);

func (*Sheet) ApplyFilter 

func (xs *Sheet) ApplyFilter()

void xlSheetApplyFilterW(SheetHandle handle);

func (*Sheet) AutoFilter 

func (xs *Sheet) AutoFilter() *AutoFilter

AutoFilterHandle xlSheetAutoFilterW(SheetHandle handle);

func (*Sheet) CellFormat 

func (xs *Sheet) CellFormat(row int, col int) *Format

FormatHandle xlSheetCellFormatW(SheetHandle handle, int row, int col);

func (*Sheet) CellType 

func (xs *Sheet) CellType(row int, col int) int

int xlSheetCellTypeW(SheetHandle handle, int row, int col);

func (*Sheet) Clear 

func (xs *Sheet) Clear(rowFirst int, rowLast int, colFirst int, colLast int)

void xlSheetClearW(SheetHandle handle, int rowFirst, int rowLast, int colFirst, int colLast);

func (*Sheet) ClearPrintArea 

func (xs *Sheet) ClearPrintArea()

void xlSheetClearPrintAreaW(SheetHandle handle);

func (*Sheet) ClearPrintRepeats 

func (xs *Sheet) ClearPrintRepeats()

void xlSheetClearPrintRepeatsW(SheetHandle handle);

func (*Sheet) ColHidden 

func (xs *Sheet) ColHidden(col int) int

int xlSheetColHiddenW(SheetHandle handle, int col);

func (*Sheet) ColWidth 

func (xs *Sheet) ColWidth(col int) float64

double xlSheetColWidthW(SheetHandle handle, int col);

func (*Sheet) ColWidthPx 

func (xs *Sheet) ColWidthPx(col int) int

int xlSheetColWidthPx(SheetHandle handle, int col)

func (*Sheet) CopyCell 

func (xs *Sheet) CopyCell(rowSrc int, colSrc int, rowDst int, colDst int) int

int xlSheetCopyCellW(SheetHandle handle, int rowSrc, int colSrc, int rowDst, int colDst); 

func (xs *Sheet) DelHyperlink(index int) int

int xlSheetDelHyperlinkW(SheetHandle handle, int index);

func (*Sheet) DelMerge 

func (xs *Sheet) DelMerge(row int, col int) int

int xlSheetDelMergeW(SheetHandle handle, int row, int col);

func (*Sheet) DelMergeByIndex 

func (xs *Sheet) DelMergeByIndex(index int) int

int xlSheetDelMergeByIndexW(SheetHandle handle, int index);

func (*Sheet) DelNamedRange 

func (xs *Sheet) DelNamedRange(name string, scopeId int) int

int xlSheetDelNamedRangeW(SheetHandle handle, const wchar_t* name, int scopeId);

func (*Sheet) DisplayGridlines 

func (xs *Sheet) DisplayGridlines() int

int xlSheetDisplayGridlinesW(SheetHandle handle);

func (*Sheet) FirstCol 

func (xs *Sheet) FirstCol() int

int xlSheetFirstColW(SheetHandle handle);

func (*Sheet) FirstRow 

func (xs *Sheet) FirstRow() int

int xlSheetFirstRowW(SheetHandle handle);

func (*Sheet) Footer 

func (xs *Sheet) Footer() string

string xlSheetFooterW(SheetHandle handle);

func (*Sheet) FooterMargin 

func (xs *Sheet) FooterMargin() float64

double xlSheetFooterMarginW(SheetHandle handle);

func (*Sheet) GetHorPageBreak 

func (xs *Sheet) GetHorPageBreak(index int) int

int xlSheetGetHorPageBreakW(SheetHandle handle, int index);

func (*Sheet) GetHorPageBreakSize 

func (xs *Sheet) GetHorPageBreakSize() int

int xlSheetGetHorPageBreakSizeW(SheetHandle handle);

func (*Sheet) GetMerge 

func (xs *Sheet) GetMerge(row int, col int) (rowFirst int, rowLast int, colFirst int, colLast int)

int xlSheetGetMergeW(SheetHandle handle, int row, int col, int* rowFirst, int* rowLast, int* colFirst, int* colLast);

func (*Sheet) GetNamedRange 

func (xs *Sheet) GetNamedRange(name string) (rowFirst int, rowLast int, colFirst int, colLast int, scopeId int, hidden int)

int xlSheetGetNamedRangeW(SheetHandle handle, const wchar_t* name, int* rowFirst, int* rowLast, int* colFirst, int* colLast, int scopeId, int* hidden);

func (*Sheet) GetPicture 

func (xs *Sheet) GetPicture(index int) (success int, rowTop int, colLeft int, rowBottom int, colRight int, width int, height int, offsetX int, offsetY int)

int xlSheetGetPictureW(SheetHandle handle, int index, int* rowTop, int* colLeft, int* rowBottom, int* colRight, 

int* width, int* height, int* offset_x, int* offset_y);

func (*Sheet) GetPrintFit 

func (xs *Sheet) GetPrintFit() (wPages int, hPages int)

int xlSheetGetPrintFitW(SheetHandle handle, int* wPages, int* hPages);

func (*Sheet) GetStrColumn 

func (xs *Sheet) GetStrColumn(col int) (columnRows []string)

func (*Sheet) GetTopLeftView 

func (xs *Sheet) GetTopLeftView() (row int, col int)

void xlSheetGetTopLeftViewW(SheetHandle handle, int* row, int* col);

func (*Sheet) GetVerPageBreak 

func (xs *Sheet) GetVerPageBreak(index int) int

int xlSheetGetVerPageBreakW(SheetHandle handle, int index);

func (*Sheet) GetVerPageBreakSize 

func (xs *Sheet) GetVerPageBreakSize() int

int xlSheetGetVerPageBreakSizeW(SheetHandle handle);

func (*Sheet) GroupCols 

func (xs *Sheet) GroupCols(colFirst int, colLast int, collapsed int) int

int xlSheetGroupColsW(SheetHandle handle, int colFirst, int colLast, int collapsed);

func (*Sheet) GroupRows 

func (xs *Sheet) GroupRows(rowFirst int, rowLast int, collapsed int) int

int xlSheetGroupRowsW(SheetHandle handle, int rowFirst, int rowLast, int collapsed);

func (*Sheet) GroupSummaryBelow 

func (xs *Sheet) GroupSummaryBelow() int

int xlSheetGroupSummaryBelowW(SheetHandle handle);

func (*Sheet) GroupSummaryRight 

func (xs *Sheet) GroupSummaryRight() int

int xlSheetGroupSummaryRightW(SheetHandle handle);

func (*Sheet) HCenter 

func (xs *Sheet) HCenter() int

int xlSheetHCenterW(SheetHandle handle);

func (*Sheet) Header 

func (xs *Sheet) Header() string

string xlSheetHeaderW(SheetHandle handle)

func (*Sheet) HeaderMargin 

func (xs *Sheet) HeaderMargin() float64

double xlSheetHeaderMarginW(SheetHandle handle);

func (*Sheet) Hidden 

func (xs *Sheet) Hidden() int

int xlSheetHiddenW(SheetHandle handle); 

func (xs *Sheet) Hyperlink(index int) (hyperlink string, rowFirst int, rowLast int, colFirst int, colLast int)

string xlSheetHyperlinkW(SheetHandle handle, int index, int* rowFirst, int* rowLast, int* colFirst, int* colLast);

func (*Sheet) HyperlinkSize 

func (xs *Sheet) HyperlinkSize() int

int xlSheetHyperlinkSizeW(SheetHandle handle);

func (*Sheet) InsertCol 

func (xs *Sheet) InsertCol(colFirst int, colLast int) int

int xlSheetInsertColW(SheetHandle handle, int colFirst, int colLast);

func (*Sheet) InsertColAndKeepRanges 

func (xs *Sheet) InsertColAndKeepRanges(colFirst int, colLast int) int

int xlSheetInsertColAndKeepRanges(SheetHandle handle, int colFirst, int colLast)

func (*Sheet) InsertRow 

func (xs *Sheet) InsertRow(rowFirst int, rowLast int) int

int xlSheetInsertRowW(SheetHandle handle, int rowFirst, int rowLast);

func (*Sheet) InsertRowAndKeepRanges 

func (xs *Sheet) InsertRowAndKeepRanges(rowFirst int, rowLast int) int

int xlSheetInsertRowAndKeepRanges(SheetHandle handle, int rowFirst, int rowLast)

func (*Sheet) IsDate 

func (xs *Sheet) IsDate(row int, col int) int

int xlSheetIsDateW(SheetHandle handle, int row, int col);

func (*Sheet) IsFormula 

func (xs *Sheet) IsFormula(row int, col int) int

int xlSheetIsFormulaW(SheetHandle handle, int row, int col);

func (*Sheet) Landscape 

func (xs *Sheet) Landscape() int

int xlSheetLandscapeW(SheetHandle handle);

func (*Sheet) LastCol 

func (xs *Sheet) LastCol() int

int xlSheetLastColW(SheetHandle handle);

func (*Sheet) LastRow 

func (xs *Sheet) LastRow() int

int xlSheetLastRowW(SheetHandle handle);

func (*Sheet) MarginBottom 

func (xs *Sheet) MarginBottom() float64

double xlSheetMarginBottomW(SheetHandle handle);

func (*Sheet) MarginLeft 

func (xs *Sheet) MarginLeft() float64

double xlSheetMarginLeftW(SheetHandle handle);

func (*Sheet) MarginRight 

func (xs *Sheet) MarginRight() float64

double xlSheetMarginRightW(SheetHandle handle);

func (*Sheet) MarginTop 

func (xs *Sheet) MarginTop() float64

double xlSheetMarginTopW(SheetHandle handle);

func (*Sheet) Merge 

func (xs *Sheet) Merge(index int) (rowFirst int, rowLast int, colFirst int, colLast int)

int xlSheetMergeW(SheetHandle handle, int index, int* rowFirst, int* rowLast, int* colFirst, int* colLast);

func (*Sheet) MergeSize 

func (xs *Sheet) MergeSize() int

int xlSheetMergeSizeW(SheetHandle handle);

func (*Sheet) Name 

func (xs *Sheet) Name() string

string xlSheetNameW();

func (*Sheet) NamedRange 

func (xs *Sheet) NamedRange(index int) (name string, rowFirst int, rowLast int, colFirst int, colLast int, scopeId int, hidden int)

string xlSheetNamedRangeW(SheetHandle handle, int index, int* rowFirst, int* rowLast, int* colFirst, int* colLast, int* scopeId, int* hidden);

func (*Sheet) NamedRangeSize 

func (xs *Sheet) NamedRangeSize() int

int xlSheetNamedRangeSizeW(SheetHandle handle);

func (*Sheet) Paper 

func (xs *Sheet) Paper() int

int xlSheetPaperW(SheetHandle handle);

func (*Sheet) PictureSize 

func (xs *Sheet) PictureSize() int

int xlSheetPictureSizeW(SheetHandle handle);

func (*Sheet) PrintArea 

func (xs *Sheet) PrintArea() (rowFirst int, rowLast int, colFirst int, colLast int)

int xlSheetPrintAreaW(SheetHandle handle, int* rowFirst, int* rowLast, int* colFirst, int* colLast);

func (*Sheet) PrintGridlines 

func (xs *Sheet) PrintGridlines() int

int xlSheetPrintGridlinesW(SheetHandle handle);

func (*Sheet) PrintRepeatCols 

func (xs *Sheet) PrintRepeatCols() (colFirst int, colLast int)

int xlSheetPrintRepeatColsW(SheetHandle handle, int* colFirst, int* colLast);

func (*Sheet) PrintRepeatRows 

func (xs *Sheet) PrintRepeatRows(rowFirst int, rowLast int) int

int xlSheetPrintRepeatRowsW(SheetHandle handle, int* rowFirst, int* rowLast);

func (*Sheet) PrintRowCol 

func (xs *Sheet) PrintRowCol() int

int xlSheetPrintRowColW(SheetHandle handle);

func (*Sheet) PrintZoom 

func (xs *Sheet) PrintZoom() int

int xlSheetPrintZoomW(SheetHandle handle);

func (*Sheet) Protect 

func (xs *Sheet) Protect() int

int xlSheetProtectW(SheetHandle handle);

func (*Sheet) ReadBlank 

func (xs *Sheet) ReadBlank(row int, col int, format *Format) int

int xlSheetReadBlankW(SheetHandle handle, int row, int col, FormatHandle* format);

func (*Sheet) ReadBool 

func (xs *Sheet) ReadBool(row int, col int) (int, *Format)

int xlSheetReadBoolW(SheetHandle handle, int row, int col, FormatHandle* format);

func (*Sheet) ReadComment 

func (xs *Sheet) ReadComment(row int, col int) string

string xlSheetReadCommentW(SheetHandle handle, int row, int col);

func (*Sheet) ReadError 

func (xs *Sheet) ReadError(row int, col int) int

int xlSheetReadErrorW(SheetHandle handle, int row, int col);

func (*Sheet) ReadFormula 

func (xs *Sheet) ReadFormula(row int, col int, format *Format) string

string xlSheetReadFormulaW(SheetHandle handle, int row, int col, FormatHandle* format);

func (*Sheet) ReadNum 

func (xs *Sheet) ReadNum(row int, col int) (float64, *Format)

double xlSheetReadNumW(SheetHandle handle, int row, int col, FormatHandle* format);

func (*Sheet) ReadStr 

func (xs *Sheet) ReadStr(row int, col int, format *Format) string

string xlSheetReadStrW(SheetHandle handle, int row, int col, FormatHandle* format)

func (*Sheet) RemoveCol 

func (xs *Sheet) RemoveCol(colFirst int, colLast int) int

int xlSheetRemoveColW(SheetHandle handle, int colFirst, int colLast);

func (*Sheet) RemoveColAndKeepRanges 

func (xs *Sheet) RemoveColAndKeepRanges(colFirst int, colLast int) int

int xlSheetRemoveColAndKeepRanges(SheetHandle handle, int colFirst, int colLast)

func (*Sheet) RemoveComment 

func (xs *Sheet) RemoveComment(row int, col int)

void xlSheetRemoveCommentW(SheetHandle handle, int row, int col);

func (*Sheet) RemoveDataValidations 

func (xs *Sheet) RemoveDataValidations()

void xlSheetRemoveDataValidationsW(SheetHandle handle);

func (*Sheet) RemoveFilter 

func (xs *Sheet) RemoveFilter()

void xlSheetRemoveFilterW(SheetHandle handle);

func (*Sheet) RemoveRow 

func (xs *Sheet) RemoveRow(rowFirst int, rowLast int) int

int xlSheetRemoveRowW(SheetHandle handle, int rowFirst, int rowLast);

func (*Sheet) RemoveRowAndKeepRanges 

func (xs *Sheet) RemoveRowAndKeepRanges(rowFirst int, rowLast int) int

int xlSheetRemoveRowAndKeepRanges(SheetHandle handle, int rowFirst, int rowLast)

func (*Sheet) RightToLeft 

func (xs *Sheet) RightToLeft() int

int xlSheetRightToLeftW(SheetHandle handle);

func (*Sheet) RowColToAddr 

func (xs *Sheet) RowColToAddr(row int, col int, rowRelative int, colRelative int) string

string xlSheetRowColToAddrW(SheetHandle handle, int row, int col, int rowRelative, int colRelative);

func (*Sheet) RowHeight 

func (xs *Sheet) RowHeight(row int) float64

double xlSheetRowHeightW(SheetHandle handle, int row);

func (*Sheet) RowHeightPx 

func (xs *Sheet) RowHeightPx(row int) int

int xlSheetRowHeightPx(SheetHandle handle, int row)

func (*Sheet) RowHidden 

func (xs *Sheet) RowHidden(row int) int

int xlSheetRowHiddenW(SheetHandle handle, int row);

func (*Sheet) SetAutoFitArea 

func (xs *Sheet) SetAutoFitArea(rowFirst int, colFirst int, rowLast int, colLast int)

void xlSheetSetAutoFitAreaW(SheetHandle handle, int rowFirst, int colFirst, int rowLast, int colLast);

func (*Sheet) SetCellFormat 

func (xs *Sheet) SetCellFormat(row int, col int, format *Format)

void xlSheetSetCellFormatW(SheetHandle handle, int row, int col, FormatHandle format);

func (*Sheet) SetCol 

func (xs *Sheet) SetCol(colFirst int, colLast int, width float64, format *Format, hidden int) int

int xlSheetSetColW(SheetHandle handle, int colFirst, int colLast, double width, FormatHandle format, int hidden);

func (*Sheet) SetColHidden 

func (xs *Sheet) SetColHidden(col int, hidden int) int

int xlSheetSetColHiddenW(SheetHandle handle, int col, int hidden);

func (*Sheet) SetDisplayGridlines 

func (xs *Sheet) SetDisplayGridlines(show int)

void xlSheetSetDisplayGridlinesW(SheetHandle handle, int show);

func (*Sheet) SetFooter 

func (xs *Sheet) SetFooter(footer string, margin float64) int

int xlSheetSetFooterW(SheetHandle handle, const wchar_t* footer, double margin);

func (*Sheet) SetGroupSummaryBelow 

func (xs *Sheet) SetGroupSummaryBelow(below int)

void xlSheetSetGroupSummaryBelowW(SheetHandle handle, int below);

func (*Sheet) SetGroupSummaryRight 

func (xs *Sheet) SetGroupSummaryRight(right int)

void xlSheetSetGroupSummaryRightW(SheetHandle handle, int right);

func (*Sheet) SetHCenter 

func (xs *Sheet) SetHCenter(hCenter int)

void xlSheetSetHCenterW(SheetHandle handle, int hCenter);

func (*Sheet) SetHeader 

func (xs *Sheet) SetHeader(header string, margin float64) int

int xlSheetSetHeaderW(SheetHandle handle, const wchar_t* header, double margin);

func (*Sheet) SetHidden 

func (xs *Sheet) SetHidden(hidden int) int

int xlSheetSetHiddenW(SheetHandle handle, int hidden);

func (*Sheet) SetHorPageBreak 

func (xs *Sheet) SetHorPageBreak(row int, pageBreak int) int

int xlSheetSetHorPageBreakW(SheetHandle handle, int row, int pageBreak);

func (*Sheet) SetLandscape 

func (xs *Sheet) SetLandscape(landscape int)

void xlSheetSetLandscapeW(SheetHandle handle, int landscape);

func (*Sheet) SetMarginBottom 

func (xs *Sheet) SetMarginBottom(margin float64)

void xlSheetSetMarginBottomW(SheetHandle handle, double margin);

func (*Sheet) SetMarginLeft 

func (xs *Sheet) SetMarginLeft(margin float64)

void xlSheetSetMarginLeftW(SheetHandle handle, double margin);

func (*Sheet) SetMarginRight 

func (xs *Sheet) SetMarginRight(margin float64)

void xlSheetSetMarginRightW(SheetHandle handle, double margin);

func (*Sheet) SetMarginTop 

func (xs *Sheet) SetMarginTop(margin float64)

void xlSheetSetMarginTopW(SheetHandle handle, double margin);

func (*Sheet) SetMerge 

func (xs *Sheet) SetMerge(rowFirst int, rowLast int, colFirst int, colLast int) int

int xlSheetSetMergeW(SheetHandle handle, int rowFirst, int rowLast, int colFirst, int colLast);

func (*Sheet) SetName 

func (xs *Sheet) SetName(name string)

void xlSheetSetNameW(SheetHandle handle, const wchar_t* name);

func (*Sheet) SetNamedRange 

func (xs *Sheet) SetNamedRange(name string, rowFirst int, rowLast int, colFirst int, colLast int, scopeId int) int

int xlSheetSetNamedRangeW(SheetHandle handle, const wchar_t* name, int rowFirst, int rowLast, int colFirst, int colLast, int scopeId);

func (*Sheet) SetPaper 

func (xs *Sheet) SetPaper(paper int)

void xlSheetSetPaperW(SheetHandle handle, int paper);

func (*Sheet) SetPicture 

func (xs *Sheet) SetPicture(row int, col int, pictureId int, scale float64, offsetX int, offsetY int, pos int)

void xlSheetSetPictureW(SheetHandle handle, int row, int col, int pictureId, double scale, int offset_x, int offset_y, int pos);

func (*Sheet) SetPicture2 

func (xs *Sheet) SetPicture2(row int, col int, pictureId int, width int, height int, offsetX int, offsetY int, pos int)

void xlSheetSetPicture2W(SheetHandle handle, int row, int col, int pictureId, int width, int height, int offset_x, int offset_y, int pos);

func (*Sheet) SetPrintArea 

func (xs *Sheet) SetPrintArea(rowFirst int, rowLast int, colFirst int, colLast int)

void xlSheetSetPrintAreaW(SheetHandle handle, int rowFirst, int rowLast, int colFirst, int colLast);

func (*Sheet) SetPrintFit 

func (xs *Sheet) SetPrintFit(wPages int, hPages int)

void xlSheetSetPrintFitW(SheetHandle handle, int wPages, int hPages);

func (*Sheet) SetPrintGridlines 

func (xs *Sheet) SetPrintGridlines(print int)

void xlSheetSetPrintGridlinesW(SheetHandle handle, int print);

func (*Sheet) SetPrintRepeatCols 

func (xs *Sheet) SetPrintRepeatCols(colFirst int, colLast int)

void xlSheetSetPrintRepeatColsW(SheetHandle handle, int colFirst, int colLast);

func (*Sheet) SetPrintRepeatRows 

func (xs *Sheet) SetPrintRepeatRows(rowFirst int, rowLast int)

void xlSheetSetPrintRepeatRowsW(SheetHandle handle, int rowFirst, int rowLast);

func (*Sheet) SetPrintRowCol 

func (xs *Sheet) SetPrintRowCol(print int)

void xlSheetSetPrintRowColW(SheetHandle handle, int print);

func (*Sheet) SetPrintZoom 

func (xs *Sheet) SetPrintZoom(zoom int)

void xlSheetSetPrintZoomW(SheetHandle handle, int zoom);

func (*Sheet) SetProtect 

func (xs *Sheet) SetProtect(protect int)

void xlSheetSetProtectW(SheetHandle handle, int protect);

func (*Sheet) SetProtectEx 

func (xs *Sheet) SetProtectEx(protect int, password string, enhancedProtection int)

void xlSheetSetProtectExW(SheetHandle handle, int protect, const wchar_t* password, int enhancedProtection);

func (*Sheet) SetRightToLeft 

func (xs *Sheet) SetRightToLeft(rightToLeft int)

void xlSheetSetRightToLeftW(SheetHandle handle, int rightToLeft);

func (*Sheet) SetRow 

func (xs *Sheet) SetRow(row int, height float64, format *Format, hidden int) int

int xlSheetSetRowW(SheetHandle handle, int row, double height, FormatHandle format, int hidden);

func (*Sheet) SetRowHidden 

func (xs *Sheet) SetRowHidden(row int, hidden int) int

int xlSheetSetRowHiddenW(SheetHandle handle, int row, int hidden);

func (*Sheet) SetTabColor 

func (xs *Sheet) SetTabColor(color int)

void xlSheetSetTabColorW(SheetHandle handle, int color);

func (*Sheet) SetTabRgbColor 

func (xs *Sheet) SetTabRgbColor(red int, green int, blue int)

void xlSheetSetTabRgbColorW(SheetHandle handle, int red, int green, int blue);

func (*Sheet) SetTopLeftView 

func (xs *Sheet) SetTopLeftView(row int, col int)

void xlSheetSetTopLeftViewW(SheetHandle handle, int row, int col);

func (*Sheet) SetVCenter 

func (xs *Sheet) SetVCenter(vCenter int)

void xlSheetSetVCenterW(SheetHandle handle, int vCenter);

func (*Sheet) SetVerPageBreak 

func (xs *Sheet) SetVerPageBreak(col int, pageBreak int) int

int xlSheetSetVerPageBreakW(SheetHandle handle, int col, int pageBreak);

func (*Sheet) SetZoom 

func (xs *Sheet) SetZoom(zoom int)

void xlSheetSetZoomW(SheetHandle handle, int zoom);

func (*Sheet) Split 

func (xs *Sheet) Split(row int, col int)

void xlSheetSplitW(SheetHandle handle, int row, int col);

func (*Sheet) SplitInfo 

func (xs *Sheet) SplitInfo() (row int, col int)

int xlSheetSplitInfoW(SheetHandle handle, int* row, int* col);

func (*Sheet) Table 

func (xs *Sheet) Table(index int) (tableName string, rowFirst int, rowLast int, colFirst int, colLast int, headerRowCount int, totalsRowCount int)

string xlSheetTableW(SheetHandle handle, int index, int* rowFirst, int* rowLast, int* colFirst, int* colLast, int* headerRowCount, int* totalsRowCount);

func (*Sheet) TableSize 

func (xs *Sheet) TableSize() int

int xlSheetTableSizeW(SheetHandle handle);

func (*Sheet) VCenter 

func (xs *Sheet) VCenter() int

int xlSheetVCenterW(SheetHandle handle);

func (*Sheet) Write 

func (xs *Sheet) Write(row int, col int, value interface{}, format *Format) int

generic write function handling multiple types at once

func (*Sheet) WriteBlank 

func (xs *Sheet) WriteBlank(row int, col int, format *Format) int

int xlSheetWriteBlankW(SheetHandle handle, int row, int col, FormatHandle format);

func (*Sheet) WriteBool 

func (xs *Sheet) WriteBool(row int, col int, value int, format *Format) int

int xlSheetWriteBoolW(SheetHandle handle, int row, int col, int value, FormatHandle format);

func (*Sheet) WriteComment 

func (xs *Sheet) WriteComment(row int, col int, value string, author string, width int, height int)

void xlSheetWriteCommentW(SheetHandle handle, int row, int col, const wchar_t* value, const wchar_t* author, int width, int height);

func (*Sheet) WriteError 

func (xs *Sheet) WriteError(row int, col int, error int, format *Format)

void xlSheetWriteErrorW(SheetHandle handle, int row, int col, int error, FormatHandle format);

func (*Sheet) WriteFormula 

func (xs *Sheet) WriteFormula(row int, col int, expr string, value interface{}, format *Format) int

generic writeFormula function handling multiple types at once

func (*Sheet) WriteFormulaBool 

func (xs *Sheet) WriteFormulaBool(row int, col int, expr string, value int, format *Format) int

int xlSheetWriteFormulaBoolW(SheetHandle handle, int row, int col, const wchar_t* expr, int value, FormatHandle format);

func (*Sheet) WriteFormulaNil 

func (xs *Sheet) WriteFormulaNil(row int, col int, expr string, format *Format) int

int xlSheetWriteFormulaW(SheetHandle handle, int row, int col, const wchar_t* value, FormatHandle format);

func (*Sheet) WriteFormulaNum 

func (xs *Sheet) WriteFormulaNum(row int, col int, expr string, value float64, format *Format) int

int xlSheetWriteFormulaNumW(SheetHandle handle, int row, int col, const wchar_t* expr, double value, FormatHandle format);

func (*Sheet) WriteFormulaStr 

func (xs *Sheet) WriteFormulaStr(row int, col int, expr string, value string, format *Format) int

int xlSheetWriteFormulaStrW(SheetHandle handle, int row, int col, const wchar_t* expr, const wchar_t* value, FormatHandle format);

func (*Sheet) WriteNum 

func (xs *Sheet) WriteNum(row int, col int, value float64, format *Format) int

int xlSheetWriteNumW(SheetHandle handle, int row, int col, double value, FormatHandle format);

func (*Sheet) WriteStr 

func (xs *Sheet) WriteStr(row int, col int, value string, format *Format) int

int xlSheetWriteStrW(SheetHandle handle, int row, int col, const wchar_t* value, FormatHandle format);

func (*Sheet) Zoom 

func (xs *Sheet) Zoom() int

int xlSheetZoomW(SheetHandle handle);

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.