cdkid Posted April 27, 2006 Share Posted April 27, 2006 I need to delete row 1 from an excel file, but I cant find anything in the ExcelCom UDF's to do this. (Sorry if I missed it) ~cdkid AutoIt Console written in C#. Write au3 code right at the console :D_FileWriteToLineWrite to a specific line in a file.My UDF Libraries: MySQL UDF Library version 1.6 MySQL Database UDF's for AutoItI have stopped updating the MySQL thread above, all future updates will be on my SVN. The svn location is:kan2.sytes.net/publicsvn/mysqlnote: This will still be available, but due to my new job, and school hours, am no longer developing this udf.My business: www.hirethebrain.com Hire The Brain HireTheBrain.com Computer Consulting, Design, Assembly and RepairOh no! I've commited Scriptocide! Link to comment Share on other sites More sharing options...
Angelia Posted May 9, 2006 Share Posted May 9, 2006 I need to delete row 1 from an excel file, but I cant find anything in the ExcelCom UDF's to do this.(Sorry if I missed it)~cdkidI'm looking for the same script. HELP. Link to comment Share on other sites More sharing options...
seandisanti Posted May 9, 2006 Share Posted May 9, 2006 i don't use excelcom udf, but i can tell you how to do it in COM this example is assuming that you've got an excel.application object already created (and named $oMyEX, and your workbook is already open in it. $wb = $oMyEX.WorkBooks("My Workbook Title") $wb.Rows("1:1").delete Link to comment Share on other sites More sharing options...
Simucal Posted May 9, 2006 Share Posted May 9, 2006 i don't use excelcom udf, but i can tell you how to do it in COM this example is assuming that you've got an excel.application object already created (and named $oMyEX, and your workbook is already open in it. $wb = $oMyEX.WorkBooks("My Workbook Title") $wb.Rows("1:1").delete Yea, it would be easy to add a row/column delete to the current UDF. I'll look into it tonight. AutoIt Scripts:Aimbot: Proof of Concept - PixelSearching Aimbot with several search/autoshoot/lock-on techniques.Sliding Toolbar - Add a nice Sliding Toolbar to your next script. Click the link to see an animation of it in action!FontInfo UDF - Get list of system fonts, or search to see if a particular font is installed.Get Extended Property UDF - Retrieve a files extended properties (e.g., video/image dimensions, file version, bitrate of song/video, etc) Link to comment Share on other sites More sharing options...
seandisanti Posted May 9, 2006 Share Posted May 9, 2006 Yea, it would be easy to add a row/column delete to the current UDF. I'll look into it tonight.i think tomorrow i'm finally going to get started on a new Excel udf... and maybe an outlook udf... Link to comment Share on other sites More sharing options...
ptrex Posted May 10, 2006 Share Posted May 10, 2006 I think thats a good idea !! Try not to put everything in one UDF, that' s overkill. My advice is to make different grouped by nature. Makes it easier to read and use, and does not burden the script when using the include too much !! Because if it's too long the include will load everything in the script, even if you need ony 3 or three UDF's. Be gentle !! Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File FinderSQLite3 Database functionality - USB Monitoring - Reading Excel using SQLRun Au3 as a Windows Service - File Monitor - Embedded Flash PlayerDynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in WindowsRead data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD WebserverMS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB ProtocolFinancial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing ControlsGuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - Update - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM - New Link to comment Share on other sites More sharing options...
seandisanti Posted May 10, 2006 Share Posted May 10, 2006 I think thats a good idea !!Try not to put everything in one UDF, that' s overkill. My advice is to make different grouped by nature.Makes it easier to read and use, and does not burden the script when using the include too much !! Because if it's too long the include will load everything in the script, even if you need ony 3 or three UDF's.Be gentle !!actually, and dev's please correct me if i'm wrong, i think i remember reading somewhere that only the functions actually used in #include 'd are put into the compiled script. so that helps reduce the need for the modulization you're speaking of. i really want to give them as many features as possible, but i'm going to try to copy dale's style from ie.au3 for documentation, examples etc, so that even if it gets as big as dale's script, it will still be as user friendly. Link to comment Share on other sites More sharing options...
ptrex Posted May 11, 2006 Share Posted May 11, 2006 @cameronsdad I hope you are right but I never read that !? If you can trace that thread to clarfy this, that would solve the mistery. I will post the question as well in the developers section. Thanks Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File FinderSQLite3 Database functionality - USB Monitoring - Reading Excel using SQLRun Au3 as a Windows Service - File Monitor - Embedded Flash PlayerDynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in WindowsRead data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD WebserverMS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB ProtocolFinancial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing ControlsGuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - Update - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM - New Link to comment Share on other sites More sharing options...
ptrex Posted May 11, 2006 Share Posted May 11, 2006 @cameronsdadAs I thought ALL the functions are incorporated in the script @ compile time !!Read the feedback from the dev' s here :http://www.autoitscript.com/forum/index.ph...0&gopid=183052&This is IMPORTANT to know when developing a new UDF.I hope this can help you to make a new plan of attack. Regardsptrex Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File FinderSQLite3 Database functionality - USB Monitoring - Reading Excel using SQLRun Au3 as a Windows Service - File Monitor - Embedded Flash PlayerDynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in WindowsRead data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD WebserverMS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB ProtocolFinancial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing ControlsGuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - Update - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM - New Link to comment Share on other sites More sharing options...
Thelazytech2 Posted May 15, 2006 Share Posted May 15, 2006 I know this is a old post, I saw it back before I figured out how to do it I modified randallc's excelcom.au3 code, here is what I added ----------I added this among the cases------------------------------------- Case StringInStr($s_MEExcelCom, "rowdel") .activesheet.Rows($i_Row&":"&$i_Row).delete .activesheet.Rows($i_Row&":"&$i_Row).Resize(1).EntireRow.Insert ---------------------------------------------------------------------------------------------- ------------I added this as a func-------------------------- func _xlrowdel(ByRef $s_FilePath,$s_i_Sheet=1,$i_Row=1,$s_i_Visible=1) _ExcelCOM($s_FilePath, $s_i_Sheet, "1", $i_Row, "rowdel", "NoSave", 1, $s_i_Visible, "NOTExit", "NOTLastRow", "NOTToColumn") EndFunc --------------------------------------------------------------------------- Hope this helps! I know you think that I know I understand what you said, but I am not sure that what I understood is what you thought. Link to comment Share on other sites More sharing options...
Simucal Posted May 16, 2006 Share Posted May 16, 2006 (edited) I know this is a old post, I saw it back before I figured out how to do itI modified randallc's excelcom.au3 code, here is what I added----------I added this among the cases-------------------------------------Case StringInStr($s_MEExcelCom, "rowdel").activesheet.Rows($i_Row&":"&$i_Row).delete.activesheet.Rows($i_Row&":"&$i_Row).Resize(1).EntireRow.Insert----------------------------------------------------------------------------------------------------------I added this as a func--------------------------func _xlrowdel(ByRef $s_FilePath,$s_i_Sheet=1,$i_Row=1,$s_i_Visible=1)_ExcelCOM($s_FilePath, $s_i_Sheet, "1", $i_Row, "rowdel", "NoSave", 1, $s_i_Visible, "NOTExit", "NOTLastRow", "NOTToColumn")EndFunc---------------------------------------------------------------------------Hope this helps!I added the _XLDeleteRow _XLDeleteColumn a few days ago. They have been updated in the current excelcom udf Edited May 16, 2006 by Simucal AutoIt Scripts:Aimbot: Proof of Concept - PixelSearching Aimbot with several search/autoshoot/lock-on techniques.Sliding Toolbar - Add a nice Sliding Toolbar to your next script. Click the link to see an animation of it in action!FontInfo UDF - Get list of system fonts, or search to see if a particular font is installed.Get Extended Property UDF - Retrieve a files extended properties (e.g., video/image dimensions, file version, bitrate of song/video, etc) 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