İptal Edildi

POC of LibreOffice Excel compatible OLE server

Applications can call various MS Excel functions through standard technique called OLE, to prove that it is possible to replace MS Excel with LibreOffice in context of applications using OLE Excel interface it is required to develop a proof-of-concept.

Functionality. POC has to:

1. Be an OLE service in Windows XP or Windows 7.

2. Be registered in OS as «[url removed, login to view]».

3. Provide OLE MS Excel 2007/2010 interface in boundaries required to work to the VBS-script provided in Appendix.

4. OLE Excel requests has to be translated to equivalent API calls of LibreOffice UNO API: VB-script → POC OLE server → LibreOffice UNO API.

5. Results of OLE calls (statues codes, returning data if there are any), has to be passed back to VBS script, as it native OLE Excel does.

Additional requirements. POC:

1. Can be written on any programming language, but must not require any of licensed run-time library.

2. Has to work in Windows XP Prof SP3 x32/x64, Windows 7 Prof x32/x64.

3. Version of LibreOffice > or newer.

Functionality check. On a computer, where MS Office (MS Excel) has never been installed we install LibreOffice. We install and register POC OLE server (can be done manually following instructions from a developer). Run LibreOffice as UNO server. Run test script. Script has to open LibreOffice Calc, create new spreadsheet file and in the first row, third column it has to insert test string 'Test', or any other value we setup in our test script.

Useful links.

1. LibreOffice UNO API [url removed, login to view]

Appendix. Test script:

'Excel example

Private Sub cmdExcel_Click()

Dim intCol

Dim intRow

Dim oXL

Dim oBook

Dim oSheet

Dim oRange

intCol = 3

intRow = 1

'Load Excel and create the object

Set oXL = CreateObject("[url removed, login to view]")

'Turn off alert messages.

[url removed, login to view] = False

'Load a new workbook and create the workbook object.

Set oBook = [url removed, login to view]

'Create the worksheet object.

Set oSheet = [url removed, login to view](1)

'Enter a value in a cell.

[url removed, login to view](intRow, intCol).Value = "Test"

'Display the Excel session.

[url removed, login to view] = True

End Sub


Beceriler: C Programlama, C++ Programlama, Python, Yazılım Mimarisi, Windows API

Daha fazlasını gör: ole calc libreoffice, ole excel, poc spreadsheet, excel ole server, createobject libreoffice calc api, excel libreoffice, the first programming language, string standard functions in c, string library in c, string library c, standard library string functions in c, standard library c, server load test, script sheets, python programming in context, python computer programming language, python computer programming, prove it test excel 2007, prove it test excel, prove it excel test 2013, prove it excel test 2010, prove it excel test 2007, prove it excel test, prove it excel 2010, prove it excel 2007 test

İşveren Hakkında:
( 1 değerlendirme ) Chelyabinsk, Russian Federation

Proje NO: #4406595

6 freelancers are bidding on average $237 for this job


I can help implement this POC.

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(18 Değerlendirme)

Please check pmb. Thanks!

in %bids___i_period_sub_35% gün içinde140%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)

Greetings, I have experience in OLE interfacing MS Office and Open/Libre Office, please check inbox for a simple demo.

in %bids___i_period_sub_35% gün içinde210%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

I can start from now and I am really interested to this [url removed, login to view] check PM.

in %bids___i_period_sub_35% gün içinde180%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

I can help

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

Hello, I can do this.

in %bids___i_period_sub_35% gün içinde440%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

Dear sir Please let me know your full spec.

in %bids___i_period_sub_35% gün içinde154%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)