Hello everybody,
First of all, I can’t describe how happy I am to have found Only Office. I have been trying for years to shake microsoft monkey off my back but I always fail because of Excel and PowerQuery.
Only Office seems to be the David that will beat the Ms Office Goliath.
Great job so far.
That aside,
I know we have Formatted Tables and I know they have some kind of data structure in the backend. It may be rudimentary but it seems like just enough to be able to substitute for Excel Tables.
One thing I couldn’t figure out is how to access this data structure in the api, so I guess they aren’t exposed.
Can we have this data structure exposed to the Api? So we can slice and dice tables with minimal effort.
VBA examples:
Dim wks as Worksheet, tbl as ListObject
Set wks as ActiveSheet
''' Add Table'
Set tbl = wks.ListObjects.Add(Source:=wks.Range("A1:B2"))
''' Rename table and columns'
tbl.DisplayName = "Tbl_AToB"
tbl.ListColumns(1).Name = "Index"
''' Slice and dice'
Dim rng as Range
Set rng = tbl.Range
Set rng = tbl.HeaderRowRange
Set rng = tbl.DatabodyRange
Set rng = tbl.ListColumns(2).DatabodyRange
''' Add rows in last and first position'
Dim d as Double
d = tbl.ListRows.Count
tbl.ListRows.Add(d +1)
tbl.ListRows.Add(1)
''' Get parent worksheet'
Dim wks2 as Worksheet
Set wks2 = tbl.Parent