Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. Visual Basic
  4. Export to OpenOffice

Export to OpenOffice

Scheduled Pinned Locked Moved Visual Basic
question
10 Posts 5 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • I Offline
    I Offline
    ivo75
    wrote on last edited by
    #1

    Can I export to OpenOffice from DataGridView? I can export to MS Word and MS Excel.

    H L D 3 Replies Last reply
    0
    • I ivo75

      Can I export to OpenOffice from DataGridView? I can export to MS Word and MS Excel.

      H Offline
      H Offline
      Henry Minute
      wrote on last edited by
      #2

      There is this[^] pdf file which is in c#, if you are able to translate. If not, I used c# openoffice interop as my search phrase, just substitute 'vb' for my 'c#' and see what you get. Bound to be something useful.

      Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” I wouldn't let CG touch my Abacus! When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.

      1 Reply Last reply
      0
      • I ivo75

        Can I export to OpenOffice from DataGridView? I can export to MS Word and MS Excel.

        L Offline
        L Offline
        Lost User
        wrote on last edited by
        #3

        ivo75 wrote:

        Can I export to OpenOffice from DataGridView? I can export to MS Word and MS Excel

        Yes. You can probably open the files that you're generating for Word and Excel using OpenOffice Writer and Calc.

        I are Troll :suss:

        I 1 Reply Last reply
        0
        • L Lost User

          ivo75 wrote:

          Can I export to OpenOffice from DataGridView? I can export to MS Word and MS Excel

          Yes. You can probably open the files that you're generating for Word and Excel using OpenOffice Writer and Calc.

          I are Troll :suss:

          I Offline
          I Offline
          ivo75
          wrote on last edited by
          #4

          OK but can I export to word or excel without word or excel in my PC.

          L 1 Reply Last reply
          0
          • I ivo75

            OK but can I export to word or excel without word or excel in my PC.

            L Offline
            L Offline
            Lost User
            wrote on last edited by
            #5

            Yes, by exporting as RTF and CSV respectively. OpenOffice knows both formats too. Exporting to CSV is most easily done using a OleDb connection.

            I are Troll :suss:

            I 1 Reply Last reply
            0
            • L Lost User

              Yes, by exporting as RTF and CSV respectively. OpenOffice knows both formats too. Exporting to CSV is most easily done using a OleDb connection.

              I are Troll :suss:

              I Offline
              I Offline
              ivo75
              wrote on last edited by
              #6

              and xls format?

              D L 2 Replies Last reply
              0
              • I ivo75

                and xls format?

                D Offline
                D Offline
                Dave Kreskowiak
                wrote on last edited by
                #7

                No. Without Word or Office installed, you cannot export to one of the Office native formats without Office installed. Well, maybe. If you're trying to export to Office 2003 native formats, you'd have to find a third party library that can write those formats. For Office 2007 and above, you can go through some of this[^] since Microsoft abandoned the proprietary formats and adopted an open XML file format instead.

                A guide to posting questions on CodeProject[^]
                Dave Kreskowiak

                L 1 Reply Last reply
                0
                • I ivo75

                  and xls format?

                  L Offline
                  L Offline
                  Lost User
                  wrote on last edited by
                  #8

                  Is proprietary. Means you'll need the software installed, just as if it were a regular application like Autocad. Or go for OpenXML :)

                  I are Troll :suss:

                  1 Reply Last reply
                  0
                  • D Dave Kreskowiak

                    No. Without Word or Office installed, you cannot export to one of the Office native formats without Office installed. Well, maybe. If you're trying to export to Office 2003 native formats, you'd have to find a third party library that can write those formats. For Office 2007 and above, you can go through some of this[^] since Microsoft abandoned the proprietary formats and adopted an open XML file format instead.

                    A guide to posting questions on CodeProject[^]
                    Dave Kreskowiak

                    L Offline
                    L Offline
                    Lost User
                    wrote on last edited by
                    #9

                    ..simply say "no", as the next question is going to be why it can't read Excel-files from Office 95/97 :)

                    I are Troll :suss:

                    1 Reply Last reply
                    0
                    • I ivo75

                      Can I export to OpenOffice from DataGridView? I can export to MS Word and MS Excel.

                      D Offline
                      D Offline
                      Dalek Dave
                      wrote on last edited by
                      #10

                      Yes see here[^]

                      ------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^] Trolls[^]

                      1 Reply Last reply
                      0
                      Reply
                      • Reply as topic
                      Log in to reply
                      • Oldest to Newest
                      • Newest to Oldest
                      • Most Votes


                      • Login

                      • Don't have an account? Register

                      • Login or register to search.
                      • First post
                        Last post
                      0
                      • Categories
                      • Recent
                      • Tags
                      • Popular
                      • World
                      • Users
                      • Groups