BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Opening file in excel using OleContainer          BorlandTalk.com Forum Index -> Delphi OLE Automation View previous topic :: View next topic   Author Message Aldwin Guest Posted: Wed Jul 26, 2006 8:12 am    Post subject: Opening file in excel using OleContainer Hi guys. How do you open or save file using OleContainer with excel as its object? I want to open or save file programmatically. Can you add codes in my example. Example: OleContainer1.CreateObject('Excel.Sheet',True); OleContainer1.DoVerb(ovShow); Thanks, Aldwin Back to top Aldwin Guest Posted: Wed Jul 26, 2006 8:12 am    Post subject: Re: Opening file in excel using OleContainer Thanks Deborah , but what i intend to do is to open a particular xls or txt file. Best regards, Aldwin "Deborah Pate (TeamB)" <d.pate (AT) blueyonder (DOT) co.not-this-bit.uk> wrote in message news:VA.000020e0.00134ba2 (AT) blueyonder (DOT) co.not-this-bit.uk... Quote: Aldwin: How do you open or save file using OleContainer with excel as its object? I want to open or save file programmatically. OleContainer1.CreateObjectFromFile('C:\Docs\Excel sheets\Book1.xls', True); OleContainer1.DoVerb(ovShow); OleContainer1.SaveAsDocument('C:\My Documents\Book1.xls'); -- Deborah Pate (TeamB) http://delphi-jedi.org TeamB don't see posts sent via Google or ISPs Use the real Borland server: newsgroups.borland.com http://www.borland.com/newsgroups/genl_faqs.html Back to top Deborah Pate (TeamB) Guest Posted: Wed Jul 26, 2006 8:12 am    Post subject: Re: Opening file in excel using OleContainer <<Aldwin: what i intend to do is to open a particular xls or txt file. Quote: That is what I did: OleContainer1.CreateObjectFromFile( 'C:\Docs\Excel sheets\Book1.xls', True); -- Deborah Pate (TeamB) http://delphi-jedi.org TeamB don't see posts sent via Google or ISPs Use the real Borland server: newsgroups.borland.com http://www.borland.com/newsgroups/genl_faqs.html Back to top Deborah Pate (TeamB) Guest Posted: Wed Jul 26, 2006 8:12 am    Post subject: Re: Opening file in excel using OleContainer <<Aldwin: How do you open or save file using OleContainer with excel as its object? I want to open or save file programmatically. Quote: OleContainer1.CreateObjectFromFile('C:\Docs\Excel sheets\Book1.xls', True); OleContainer1.DoVerb(ovShow); OleContainer1.SaveAsDocument('C:\My Documents\Book1.xls'); -- Deborah Pate (TeamB) http://delphi-jedi.org TeamB don't see posts sent via Google or ISPs Use the real Borland server: newsgroups.borland.com http://www.borland.com/newsgroups/genl_faqs.html Back to top Aldwin Guest Posted: Wed Jul 26, 2006 6:02 pm    Post subject: Re: Opening file in excel using OleContainer Thanks Deborah, I tried what you've inform me. But i stil have a question, how can I use the properties or method of an excel object in a olecontainer? Best regards, Aldwin "Deborah Pate (TeamB)" <d.pate (AT) blueyonder (DOT) co.not-this-bit.uk> wrote in message news:VA.000020e1.003af93a (AT) blueyonder (DOT) co.not-this-bit.uk... Quote: Aldwin: what i intend to do is to open a particular xls or txt file. That is what I did: OleContainer1.CreateObjectFromFile( 'C:\Docs\Excel sheets\Book1.xls', True); -- Deborah Pate (TeamB) http://delphi-jedi.org TeamB don't see posts sent via Google or ISPs Use the real Borland server: newsgroups.borland.com http://www.borland.com/newsgroups/genl_faqs.html Back to top Aldwin Guest Posted: Wed Jul 26, 2006 7:48 pm    Post subject: Re: Opening file in excel using OleContainer Oki doki Deborah, .. So you mean I can't open a text file in a excel object, the only command to do that is by olecontainer.LoadFromFile()? The reason I'm asking you about opening a file is that I wanted to open a Comma delimited text file and import it in excel using delphi. I also used the codes below just to import a text file to excel, but it didn't do the proper comma delimited feature. I also used the ExcelApplication object with a property Opentext, eventhough I've managed to put the exact parameters that I've found in MSDN library, still luck is not on my side, co'z I've encountered an ole error. I've also post that here with a subject Opening Text file in excel using delphi. Thank you very much for you time. Example A. objExcel := CreateOleObject('Excel.Application'); objExcel.WorkBooks.Open(ExcelPath); Sheet := objExcel.WorkSheets[iSheetIndex]; Example B. objExcel := CreateOleObject('Excel.Application'); objExcel.WorkBooks.OpenText(ExcelPath); Sheet := objExcel.WorkSheets[iSheetIndex]; Best regards, Aldwin "Deborah Pate (TeamB)" <d.pate (AT) blueyonder (DOT) co.not-this-bit.uk> wrote in message news:VA.000020e3.0188db0b (AT) blueyonder (DOT) co.not-this-bit.uk... Quote: Aldwin: how can I use the properties or method of an excel object in a olecontainer? The actual Excel object in an olecontainer is a workbook. So you can do things like this: var VExcel, VWB, VWS: OleVariant; .. Olecontainer1.Doverb(ovPrimary); VWB := Olecontainer1.Oleobject; VExcel := VWB.Application; VWS := VWB.ActiveSheet; Caption := VWS.Name; VWS.Range['A1'].Value := 'First cell'; Caption := VWS.Cells.Item[1, 2].Value; VExcel.ActiveWindow.DisplayGridlines := False; You can use nearly all of the automation commands that you would use automating Excel outside of an olecontainer. The exceptions are things like opening and saving files, which you have to do using the olecontainer's methods (since it needs to be in charge of those actions). -- Deborah Pate (TeamB) http://delphi-jedi.org TeamB don't see posts sent via Google or ISPs Use the real Borland server: newsgroups.borland.com http://www.borland.com/newsgroups/genl_faqs.html Back to top Deborah Pate (TeamB) Guest Posted: Wed Jul 26, 2006 8:05 pm    Post subject: Re: Opening file in excel using OleContainer <<Aldwin: how can I use the properties or method of an excel object in a olecontainer? Quote: The actual Excel object in an olecontainer is a workbook. So you can do things like this: var VExcel, VWB, VWS: OleVariant; ... Olecontainer1.Doverb(ovPrimary); VWB := Olecontainer1.Oleobject; VExcel := VWB.Application; VWS := VWB.ActiveSheet; Caption := VWS.Name; VWS.Range['A1'].Value := 'First cell'; Caption := VWS.Cells.Item[1, 2].Value; VExcel.ActiveWindow.DisplayGridlines := False; You can use nearly all of the automation commands that you would use automating Excel outside of an olecontainer. The exceptions are things like opening and saving files, which you have to do using the olecontainer's methods (since it needs to be in charge of those actions). -- Deborah Pate (TeamB) http://delphi-jedi.org TeamB don't see posts sent via Google or ISPs Use the real Borland server: newsgroups.borland.com http://www.borland.com/newsgroups/genl_faqs.html Back to top Deborah Pate (TeamB) Guest Posted: Wed Jul 26, 2006 10:15 pm    Post subject: Re: Opening file in excel using OleContainer <<Aldwin: I wanted to open a Comma delimited text file and import it in excel using delphi. Quote: This works for me. If it doesn't for you, could you tell us the exact error you get? uses ComObj; procedure TForm1.Button1Click(Sender: TObject); var objExcel, Sheet: OleVariant; begin objExcel := CreateOleObject('Excel.Application'); ObjExcel.Visible := True; objExcel.WorkBooks.OpenText('C:\Docs\Test1.csv'); Sheet := objExcel.WorkSheets[1]; Caption := Sheet.Name; end; If you don't need to use a TOleContainer, then I'd advise avoiding them, as they just add complications. -- Deborah Pate (TeamB) http://delphi-jedi.org TeamB don't see posts sent via Google or ISPs Use the real Borland server: newsgroups.borland.com http://www.borland.com/newsgroups/genl_faqs.html Back to top Aldwin Guest Posted: Thu Jul 27, 2006 6:31 pm    Post subject: Re: Opening file in excel using OleContainer Thanks Deborah. I've managed to solve the problem. I've just put additional parameters like delimiter , format and text qualifier.. All the best, Aldwin "Deborah Pate (TeamB)" <d.pate (AT) blueyonder (DOT) co.not-this-bit.uk> wrote in message news:VA.000020e4.00195faa (AT) blueyonder (DOT) co.not-this-bit.uk... Quote: Aldwin: I wanted to open a Comma delimited text file and import it in excel using delphi. This works for me. If it doesn't for you, could you tell us the exact error you get? uses ComObj; procedure TForm1.Button1Click(Sender: TObject); var objExcel, Sheet: OleVariant; begin objExcel := CreateOleObject('Excel.Application'); ObjExcel.Visible := True; objExcel.WorkBooks.OpenText('C:\Docs\Test1.csv'); Sheet := objExcel.WorkSheets[1]; Caption := Sheet.Name; end; If you don't need to use a TOleContainer, then I'd advise avoiding them, as they just add complications. -- Deborah Pate (TeamB) http://delphi-jedi.org TeamB don't see posts sent via Google or ISPs Use the real Borland server: newsgroups.borland.com http://www.borland.com/newsgroups/genl_faqs.html Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi OLE Automation All times are GMT Page 1 of 1   Jump to: Select a forum C++ Builder Newsgroups----------------C++ BuilderC++ Builder (ActiveX)C++ Builder (Announcements)C++ Builder (Command Line Tools)C++ Builder DatabasesC++ Builder Databases (ADO)C++ Builder Databases (Desktop)C++ Builder Databases (InterBase Express)C++ Builder Databases (Multi-Tier)C++ Builder Databases (SQL Servers)C++ Builder (Graphics)C++ Builder (IDE)C++ Builder (Internet)C++ Builder (Internet Socket)C++ Builder (Internet Web)C++ Builder (Jobs)C++ Builder (Language)C++ Builder (Language C++)C++ Builder (Compatibility with MFC)C++ Builder (Native API)C++ Builder (Non-Technical)C++ Builder (Students)C++ Builder (Third Party Tools)C++ Builder (Upgrade)C++ Builder (VCL)C++ Builder (VCL Components Usage)C++ Builder (VCL Components Development)C++ Builder (VCL Usage)C++ Builder (WinAPI)C++ Builder Installation Delphi Newsgroups----------------Delphi (General)Delphi ActiveX Controls UsageDelphi ActiveX Controls DevelopmentDelphi As400Delphi DatabasesDelphi Databases (ADO)Delphi Databases (dbExpress)Delphi Databases (Desktop)Delphi Databases (InterBase Express)Delphi Databases (Multi-Tier)Delphi Databases (SQL Servers)Delphi DeploymentDelphi GraphicsDelphi IDEDelphi InternationalizationDelphi InternetDelphi Internet Isapi-WebBrokerDelphi Internet WebSnapDelphi Internet WinsockDelphi JobsDelphi Language BASMDelphi Language ObjectPascalDelphi Model Driven Architecture (General)Delphi Model Driven Architecture (Third Party)Delphi MultimediaDelphi Native APIDelphi Non-TechnicalDelphi ObjectPascalDelphi OLE AutomationDelphi OO designDelphi OpenToolsAPIDelphi Reporting-ChartingDelphi RTLDelphi StudentsDelphi TeamSourceDelphi Thirdparty ToolsDelphi Thirdparty Tools (General)Delphi Thirdparty Tools (IntraWeb)Delphi Thirdparty Tools (RaveReports)Delphi UpgradeDelphi VCLDelphi VCL ComponentsDelphi VCL Components UsingDelphi VCL Components WritingDelphi WebServices SOAPDelphi WinAPIDelphi XMLDelphi Installationcomp.lang.pascal.delphi.components.misccomp.lang.pascal.delphi.components.usagecomp.lang.pascal.delphi.components.writingcomp.lang.pascal.delphi.databasescomp.lang.pascal.delphi.misccomp.sources.delphi JBuilder Newsgroups----------------JBuilderJBuilder AnnouncementsJBuilder Applet IssuesJBuilder As400JBuilder CompilerJBuilder CORBA/RMIJBuilder DatabasesJBuilder DB SwingJBuilder DebuggerJBuilder DeploymentJBuilder DocumentationJBuilder EnterpriseJBuilder HandheldJBuilder IDEJBuilder JavaJBuilder JavaAPIJBuilder Java LanguageJBuilder Java SwingJBuilder Java BeansJBuilder Java Beans UsageJBuilder Java Beans DevelopmentJBuilder JBCLJBuilder JDataStoreJBuilder JobsJBuilder LinuxJBuilder MacintoshJBuilder & MobileSetJBuilder MultiLingual AppsJBuilder Non-TechnicalJBuilder OpenToolsJBuilder Servlets (JSP)JBuilder StudentsJBuilder Team DevelopmentJBuilder Thirdparty ToolsJBuilder UpgradeJBuilder Installation InterBase Newsgroups----------------InterBaseInterBase Bug DiscussionInterBase GeneralInterBase IBConsoleInterBase OpenSourceInterBase ReplicationInterBase SQLInterBase ThirdpartyInterBase Installation Miscellaneous Borland Newsgroups----------------AppCenterAppServerEnteraVisiBroker  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.