Click here to Skip to main content

Submit your article

OpenOffice

OpenOffice

Great Reads

PyOOCalc - Python Libre/Open Office Calc Interface API (UNO)

by The Purple

Create Libre/Open Office Calc documents, reports on Python

Automating OpenOffice Calc from Visual Studio 2022 using C#

by chionatech

A step by step guide on how to automate Apache OpenOffice Calc using Visual Studio 2022 and the C# language

Latest Articles

Automating OpenOffice Calc from Visual Studio 2022 using C#

by chionatech

A step by step guide on how to automate Apache OpenOffice Calc using Visual Studio 2022 and the C# language

PyOOCalc - Python Libre/Open Office Calc Interface API (UNO)

by The Purple

Create Libre/Open Office Calc documents, reports on Python

All Articles

OpenOffice

Automate open office document (.odt) using c#.net

31 Oct 2013 by Volynsky Alex

Hi comred,here http://wiki.openoffice.org/wiki/AODL_example_17[^] example NUnit test will show how to create a new OpenDocument text document by using AODL and send it to a printer by using the new OpenOfficeLib.Here http://aodl.sourceforge.net/about.html[^] is another example of AODL...

Automate open office document (.odt) using c#.net

31 Oct 2013 by comred

Hello developer, I am struggling to automate Open Office document using C# .Net. I have done some work regarding office automation using Microsoft interope libraries. But in case of Open Office I have found something like AODL libraries. I have downloaded it from the Apache...

Add Multiple Images to Excel spreadsheet

12 Feb 2012 by YKK Reddy

Hi All,I have a requirement in my project to add multiple images on the fly. The images are dynamically obtained from another source (the image path is obtained) and i need to paste them at a particular location on the excel sheet.I am able to add single image successfully to spreadsheet...

Office-Automation

Open Office database with c#

6 Jun 2012 by Soft009

HI,Current...

How to disable menu items like Save, Save As in OpenOffice Calc using Macro?

6 Nov 2015 by Maciej Los

Above code refers to Microsoft Office Excel BeforeSave event, but you mentioned that you use OpenOffice Calc!See:Using a Global Library to Automate OOo Calc[^]Document Events[^]Creating a simple macro[^]Google book: Using Spreadsheets in OpenOffice.org 3.3[^]

PyOOCalc - Python Libre/Open Office Calc Interface API (UNO)

20 Dec 2015 by The Purple

Create Libre/Open Office Calc documents, reports on Python

How do I write a code on

15 Apr 2021 by Richard MacCutchan

Get together with your classmate Malik who posted: How do I write a code[^]

Open Office database connection in Visual Basic 6.0

1 Sep 2011 by Simon_Whale

Have a read of this Openoffice database connection using vb6[^]Just scroll to the bottom of the page for the answer

OpenOfficeXML implementation of adding a comment in word docx file programmatically

20 Sep 2011 by Aksh@169

Hi,I need a help. I have a requirement of searching for text that is in paranthesis ( ) in a docx file and then adding a comment at this point. All this(i.e. adding a comment at the appropriate point) needs to be done programmatically in C#.The text of the comment should be same as the text...

VB.NET working with OpenOffice SpreadSheet Calc

4 Oct 2011 by hansoctantan

I have a code that write a ODS file. Dim xr = Replace("C:\Documents and Settings\SOFT07\Desktop\", "\", "/") + "/Test.ods" Dim xr2 = Replace("C:\Documents and Settings\SOFT07\Desktop\", "\", "/") & "/TestC.ods" FileCopy(xr, xr2) Url = "file:///" & xr2 ...

Open Office Spreadsheet connection with c#.net

15 Nov 2011 by krunal25

Hi everyone,I need to connect Open-Office spreadsheet with c#.net, i dont know how to connect with it and also i want to read and write data for that spreadsheet...Please help me how to do this...Regards,Krunal panchal

Open Office Spreadsheet connection with c#.net

15 Nov 2011 by Richard MacCutchan

See here[^] for some starting points.

Use Openoffice convert doc to pdf

3 Jan 2012 by jedchan

When I change a large number of files into form of PDF using OpenOffice, the memory of soffice.bin process is continued to increase. When it ups to a certain extent, the conversion of soffice.bin is failed. Every time, after transformed a file, I always run XComponent to dispose. Why the memory...

How to add image at a particular cell location in C# using OpenXML

30 Jan 2012 by YKK Reddy

Hi,I need to add image at a particular cell location in an Excel sheet. I an using OpenXML approach for this. Can anyone suggest me how to achieve this ?For example, i need to put an image at cell "D5".Thanks and Regards,YKK Reddy

Office-Automation

How to copy rows and paste at the end of the Excel sheet using OpenXML

30 Jan 2012 by YKK Reddy

Hi All,I have a requirement in my project that i need to copy few parts of my excel sheet and paste it in another part of the same sheet.Can anyone help me in achieving this ?For example, i need to copy rows 1 through 25 and paste them at Row number 40.Thanks and Regards,YKK Reddy

Office-Automation

How to add rows in excel sheet using OpenXML

30 Jan 2012 by YKK Reddy

Hi,I am facing a problem in adding/inserting new/existing rows in between a excel sheet.Can anyone help me in achieving this ?For example, i need to copy Row# 10 and paste it after Row# 20.Kindly help.Thanks and Regards,YKK Reddy

Office-Automation

How to add rows in excel sheet using OpenXML

30 Jan 2012 by Ganesan Senthilvel

Herez sample code:private static Cell InsertCellInWorksheet(string columnName, uint rowIndex, WorksheetPart worksheetPart) { Worksheet worksheet = worksheetPart.Worksheet; SheetData sheetData = worksheet.GetFirstChild(); string...

Office-Automation

How to add image at a particular cell location in C# using OpenXML

31 Jan 2012 by RDBurmon

Read this two blog . You would definitely get some insighthttp://polymathprogrammer.com/2010/11/10/how-to-insert-multiple-images-in-excel-open-xml/[^]http://www.pcreview.co.uk/forums/can-you-anchor-image-cell-excel-t3493964.html[^]

Office-Automation

How to copy rows and paste at the end of the Excel sheet using OpenXML

7 Feb 2012 by YKK Reddy

The solution can be found at http://products.e-dbxml.net/openxml-spreadsheet/post/openxml-spreadsheet-copy-inser[^]There are few methods for getting cell row index, column index etc which has to be written separately.

Office-Automation

Cannot insert image to an excel sheet with Comments

8 Feb 2012 by YKK Reddy

Hi All,I am facing a problem in inserting the image in Sheet which has cell (that has comments inserted).I mean to say few cells in my Excel sheet have comments inserted. When i try to insert image using OpenXML SDK V2.0, the output excel file becomes unreadable.I have done the same...

Office-Automation

Cannot insert image to an excel sheet with Comments

8 Feb 2012 by SayreCC

Hi,You can visit this link http://aspsnippets.com/Search.aspx?q=image , all sample regarding the image, saving, excel has on this site.Hope that one can help.Thank You.

Office-Automation

Cannot insert image to an excel sheet with Comments

12 Feb 2012 by YKK Reddy

Hi,For those who need this i am posting the solution also.I posted the same question in MSDN Microsoft forums and got the solution.I am posting the link below. Go through the entire post if...

Office-Automation

How to add image at a particular cell location in C# using OpenXML

12 Feb 2012 by YKK Reddy

Hi, For those who need this i am posting the solution also.I posted the same question in MSDN Microsoft forums and got the solution. I am posting the link below. Go through the entire post if...

Office-Automation

Add Multiple Images to Excel spreadsheet

13 Feb 2012 by YKK Reddy

Hi,I have solved it myself. I am posting it here just in case anyone else needs.I modified the code for the "Drawing" class. The below code is mentioned:if (imageNumber == 1) { Drawing drawing = new Drawing() { Id = "rId" + drawingPartId.ToString() }; ...

Office-Automation

Adjust cell width and Height according to image coordinates in OpenXML

15 Feb 2012 by YKK Reddy

Hi All,I am using OpenXML SDK 2.0 and i am having a requirement that i need to insert an image into a particular cell and adjust the cell width and height (in other words corresponding Row Height and Column Width) according to the image Horizontal and Vertical Pixels.I am planning to use...

Office-Automation

Adjust cell width and Height according to image coordinates in OpenXML

15 Feb 2012 by YKK Reddy

Hi All,After many attempts, i finally found out the solution. Thought of sharing with you guys.int iImageWidth = 0, iImageHeight = 0, iOffset = 10; using (Bitmap bitmap = new Bitmap(strImageFile)) { iImageHeight = bitmap.Height; ...

Office-Automation

Is It Possible To Convert File PDF To Word Using Open Office In C#.Net?

2 Mar 2012 by andy(-RKO)

Hello ,Can Any Body Tell Me Is It Possible To Convert File PDF To Word Using Open Office In C#.Net?and if Yes then how we implement that?Thanx In Advance..:-)

Is It Possible To Convert File PDF To Word Using Open Office In C#.Net?

17 May 2012 by dhavalmore13986

follow this linkhttp://forums.asp.net/t/1664565.aspx/1?Convert+pdf+to+jpg+or+any+other+format

Is It Possible To Convert File PDF To Word Using Open Office In C#.Net?

17 May 2012 by andy(-RKO)

Hello All,i have this issue using third party dll that is PDF Foucus Net.Thank You All

Open Office database with c#

6 Jun 2012 by Abhinav S

http://wiki.se...

Cannot create ActiveX component error

1 Sep 2013 by Kiss Gergely 85

Hi,I would like to ask for help in the following topic. I made this code called in IIS Web Service in order to create pdf file from office documents (Excel, Word, etc.):Dim oSM, oDesk, oDoc As Object 'OOo objectsDim OpenParam(1) As Object 'Parameters to open the docDim SaveParam(1)...

How to read excel data to datatable using OPENXML?

17 Sep 2013 by Jitendra Ku. Sahoo

Hi All,I want to read data from an excel file and want to store it in a datatable. Previously I was using interop excel.But it give COM exception many time.So I want to switch to OPENXML. But I am unable to read xls file in it .It is showing Corrupted data exception.Any 1 has sample code to...

How to read excel data to datatable using OPENXML?

17 Sep 2013 by hypermellow

Excel connection via OLEDB:How to query and display excel data by using ASP.NET, ADO.NET, and Visual C# .NETExcel connectivity using NPOI:NPOIHope it helps.

How to read excel data to datatable using OPENXML?

17 Sep 2013 by PIEBALDconsult

I don't know. I use ADO.net, OleDB, and the Jet or ACE engine to read and write Excel like a database.http://www.microsoft.com/en-us/download/details.aspx?id=13255[^]http://www.connectionstrings.com/excel/[^]

How to read excel data to datatable using OPENXML?

17 Sep 2013 by Jitendra Ku. Sahoo

Thanks all for your response.Is dere any way to manage xls, xlsx file in OPENXML?

How do I Copy Text from one openOffice Wirter to another?

18 Nov 2013 by comred

Hi, I want to copy text from one Open-Office Writer i.e. .odt file to another odt file's textframe. I am not getting any correct method to do the same. I am very much familiar to do the same with Microsoft Interope assembly, but not getting it in Open Office. Any help for the same...

Open Office database with c#

30 Jan 2014 by Member 10562032

https://wiki.openoffice.org/wi...

General Input/Output Error Problem

20 Mar 2014 by Amalraj Ramesh

General Input/Output Error Problem help meIm generating docx file using Open XML When i open the file in Oppenoffice,org Writer its throw General Input/Output ErrorMy codepublic void WordprocessingFromString(string InputPath, string OutputPath, string InputDir) { ...

How to disable menu items like Save, Save As in OpenOffice Calc using Macro?

5 Nov 2015 by VR Karthikeyan

Hi,I want to disable Save and Save As options in the File Menu of OpenOffice Calc using Macro. I have tried the following code,Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) MsgBox "You can't save this workbook!" Cancel = TrueEnd SubBut it doesn't...

How do I write a code on

15 Apr 2021 by OriginalGriff

We are more than willing to help those that are stuck: but that doesn't mean that we are here to do it all for you! We can't do all the work, you are either getting paid for this, or it's part of your grades and it wouldn't be at all fair for us...

Is possible call UNO executable in pure C

24 Aug 2022 by armanvaneld

Hi like of title , is possible call UNO executable in pure C (not in C++), if yes anyone have some example ?? (like open calc insert hello world in first cell close and save ) thanks to all those who want to answer me (openoffice 6.4.7.2 on linux...

Is possible call UNO executable in pure C

24 Aug 2022 by Richard MacCutchan

There is a a support forum on the UNO web site. You are more likely to get an answer there.

Is possible call UNO executable in pure C

24 Aug 2022 by CPallini

In my opinion, you have to use C++. I am not saying it is impossible with C (after all, Jeff Glatt showed us how to access COM in plain C[^]) , but it would be very difficult.

How to trasform XML (ods) to datagridview

2 Oct 2023 by Marco Giglio

I'm learning how to convert an ODS file into a DataGridView. I've already learned how to open the ods file and extract the XML file. I can't figure out how to take any data with texts and turn it into rows and columns on a DataGridView. I just...

How to trasform XML (ods) to datagridview

25 Sep 2023 by Richard MacCutchan

You just need to build the DataGridView Control - Windows Forms .NET Framework | Microsoft Learn[^] columns and rows, and add the data that you want to display.

Automating OpenOffice Calc from Visual Studio 2022 using C#

3 Apr 2023 by chionatech

A step by step guide on how to automate Apache OpenOffice Calc using Visual Studio 2022 and the C# language

How to add rows in excel sheet using OpenXML

7 Feb 2012 by YKK Reddy

private static Row CreateRow(Row refRow, SheetData sheetData, Row refRow1) { uint newRowIndex = 0; var newRow = new Row() { RowIndex = refRow.RowIndex.Value }; // Loop through all the rows in the worksheet with higher row // index...

Office-Automation

Inserting picture in calc using vb.net

6 Sep 2012 by evilson

I made an coding to create a open-office calc document using a vb.netPublic Class OoCalcPublic Context As unoidl.com.sun.star.uno.XComponentContextPublic Factory As unoidl.com.sun.star.lang.XMultiServiceFactoryPublic Loader As unoidl.com.sun.star.frame.XComponentLoaderPublic Doc As...

Open Office database connection in Visual Basic 6.0

31 Aug 2011 by Member 8181988

HiI want to connect Open Office 3.3 database in visual basic 6. I have tried doing this, like in Access database connection, but it did not work. What can I do?ThanksBhausaheb Funde.

Is It Possible To Convert File PDF To Word Using Open Office In C#.Net?

2 Mar 2012 by Richard MacCutchan

Yes, but you will need to get hold of a PDF library, such as iTextSharp[^] to read the PDF.

Open Office database with c#

6 Jun 2012 by codeBegin

I just want to set the connection with the database in c#Yes it is possible, for that you have to follow some steps:1) First add "using System.Data.OleDb;" at to top of the CS file.2) Create connection string and open connection.For access 2007string ConnStr =...

How do I write a code on

15 Apr 2021 by Harriet Julliet

using the player, Junior Player and Senior Player class declarations below attempt the question class Player { string name; string PlayerId; public: Player(); Player(string, string); void Register(string, string); void...

Is It Possible To Convert File PDF To Word Using Open Office In C#.Net?

3 Mar 2012 by Sergey Alexandrovich Kryukov

Just an idea: source code of Open Office is available. You could download it and see how it works. I think it could be pretty bit work though, even if you try to extract and use existing...

Export To DOCX format

10 Mar 2014 by Amalraj Ramesh

Hi--I am finding that reports exported to Word cannot be opened in OpenOffice Writer 4."General Error. General input/output error."Is anyone else having this issue or have gotten it to work?