smellyfingers Posted March 6, 2013 Share Posted March 6, 2013 Hi im trying to import a .txt to a new excel book and that works as planned so far accept it´s missing the zeros in the nr rows, is there a parameter to just format the whole book as text before the import? Thanx! Link to comment Share on other sites More sharing options...
water Posted March 6, 2013 Share Posted March 6, 2013 How do you import the data? Manually or by script? My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
smellyfingers Posted March 6, 2013 Author Share Posted March 6, 2013 Hi water, i do it by script,like this #include <Excel.au3> #include <Array.au3> Dim $oExcel $oExcel = ObjCreate("Excel.Application") $oExcel.Visible = 1 $oExcel.Workbooks.OpenText("\\DubbelkollOMT\Mobilnummer.txt", _ 1252, _ ; Origin 1, _ ; StartRow 1, _ ; DataType = x1Delimited 2, _ ; TextQualifier = x1DoubleQuote False, _ ; ConsecutiveDelimiter True, _ ; Tab False, _ ; Semicolon False, _ ; Comma False, _ ; Space False _ ; Other ) _ExcelBookSaveAs($oExcel, "\\DubbelkollOMT\Mobilnummer.xls", "xls", 0, 1) _ExcelBookClose($oExcel) Link to comment Share on other sites More sharing options...
water Posted March 6, 2013 Share Posted March 6, 2013 (edited) You could pass parameter FieldInfo. An array containing parse information for individual columns of data. Set the column to xlTextFormat. Edited March 6, 2013 by water My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
smellyfingers Posted March 6, 2013 Author Share Posted March 6, 2013 Funny, i was looking at that page just before you posted , but how do i actually pass that parameter in a correct way based on the script example? Thanx Link to comment Share on other sites More sharing options...
water Posted March 6, 2013 Share Posted March 6, 2013 (edited) Please check the of the Excel UDF I'm working on. It's just an alpha version but function _Excel_BookOpenText should do what you want. Check example 1 in _Excel_BookOpenText.au3 for an example. Edited March 6, 2013 by water My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
smellyfingers Posted March 6, 2013 Author Share Posted March 6, 2013 Sweet thanx i will check it out tomorrow when I'm back at work, thanx 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