maniootek Posted August 6, 2020 Share Posted August 6, 2020 (edited) Is it possible to format cell range as table with some build in method/function in Excel? Edited August 6, 2020 by maniootek Link to comment Share on other sites More sharing options...
Nine Posted August 6, 2020 Share Posted August 6, 2020 Not exactly, but once you got the Excel Object, you can used any methods or properties that come with the object. See here. “They did not know it was impossible, so they did it” ― Mark Twain Spoiler Block all input without UAC Save/Retrieve Images to/from Text Monitor Management (VCP commands) Tool to search in text (au3) files Date Range Picker Virtual Desktop Manager Sudoku Game 2020 Overlapped Named Pipe IPC HotString 2.0 - Hot keys with string x64 Bitwise Operations Multi-keyboards HotKeySet Recursive Array Display Fast and simple WCD IPC Multiple Folders Selector Printer Manager GIF Animation (cached) Screen Scraping Multi-Threading Made Easy Link to comment Share on other sites More sharing options...
Subz Posted August 6, 2020 Share Posted August 6, 2020 Just record a macro performing the tasks and then convert the vb as Nine suggested, for example: #include <Excel.au3> Global Const $xlSrcRange = 1 $oExcel = _Excel_Open() $oWorkbook = _Excel_BookNew($oExcel) $oWorkbook.ActiveSheet.ListObjects.Add($xlSrcRange, $oWorkbook.ActiveSheet.Range("$A$1:$H$3"),"",$xlYes).Name = "Table1" $oRange = $oWorkbook.ActiveSheet.Range("Table1[#All]").Select $oWorkbook.ActiveSheet.ListObjects("Table1").TableStyle = "TableStyleLight3" maniootek 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now