FilesExpand file tree

 develop

/

xlsxreader.lua

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

59 lines (48 loc) · 1.44 KB

 develop

/

xlsxreader.lua

Copy path

Top

File metadata and controls

• Code
• Blame

59 lines (48 loc) · 1.44 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

local _ENV = mkmodule('plugins.xlsxreader')

XlsxioSheetReader = defclass(XlsxioSheetReader, nil)

XlsxioSheetReader.ATTRS{

-- handle to the open sheet. required.

sheet_handle = DEFAULT_NIL,

}

function XlsxioSheetReader:init()

if not self.sheet_handle then

error('XlsxSheetReader: sheet_handle is required')

end

end

function XlsxioSheetReader:close()

close_sheet(self.sheet_handle)

self.sheet_handle = nil

end

function XlsxioSheetReader:get_row(max_tokens)

return get_row(self.sheet_handle, max_tokens)

end

XlsxioReader = defclass(XlsxioReader, nil)

XlsxioReader.ATTRS{

-- full or relative path to the target .xlsx file. required.

filepath = DEFAULT_NIL,

}

function open(filepath)

return XlsxioReader{filepath=filepath}

end

function XlsxioReader:init()

if not self.filepath then

error('XlsxReader: filepath is required')

end

self.xlsx_handle = open_xlsx_file(self.filepath)

if not self.xlsx_handle then

qerror(('failed to open "%s"'):format(self.filepath))

end

end

function XlsxioReader:close()

close_xlsx_file(self.xlsx_handle)

self.xlsx_handle = nil

end

function XlsxioReader:list_sheets()

return list_sheets(self.xlsx_handle)

end

-- if sheet_name is empty or nil, opens the first sheet

function XlsxioReader:open_sheet(sheet_name)

local sheet_handle = open_sheet(self.xlsx_handle, sheet_name)

return XlsxioSheetReader{sheet_handle=sheet_handle}

end

return _ENV