Results 1 to 8 of 8

Thread: VB6 - Export flexgrid to kingsoft spreadsheet 2013

  1. #1

    Thread Starter
    Registered User
    Join Date
    Mar 2014
    Posts
    6

    Smile VB6 - Export flexgrid to kingsoft spreadsheet 2013

    How can I export flexgrid data to kingsoft spreadsheet 2013 in vb6, please somebody help me.......

  2. #2
    PowerPoster Arnoutdv's Avatar
    Join Date
    Oct 2013
    Posts
    6,747

    Re: VB6 - Export flexgrid to kingsoft spreadsheet 2013

    What is a "kingsoft" spreadsheet?

  3. #3
    PowerPoster Arnoutdv's Avatar
    Join Date
    Oct 2013
    Posts
    6,747

    Re: VB6 - Export flexgrid to kingsoft spreadsheet 2013

    According to their website the spreadsheet tool is capable of reading and writing XLS and XLSX files.
    So just create an XLSX file on the fly and write it to disk.

    I don't know if the KingSoft Spreadsheet application support any kind of automation.

    In the Codebank is a sample how to create XLSX files:
    http://www.vbforums.com/showthread.p...7-Excel-Writer

  4. #4

    Thread Starter
    Registered User
    Join Date
    Mar 2014
    Posts
    6

    Re: VB6 - Export flexgrid to kingsoft spreadsheet 2013

    I've ever export data from flexgrid to excel at vb6 using reference "Microsoft Excel 12.0 Object Library", but vb6 doesn't support for Kingsoft. Does anybody know how to export data from flexgrid to kingsoft spreadsheet using vb6. What should I do?

  5. #5
    PowerPoster Arnoutdv's Avatar
    Join Date
    Oct 2013
    Posts
    6,747

    Re: VB6 - Export flexgrid to kingsoft spreadsheet 2013

    Using the Excel Object Library you are using Office Automation.
    I don't know if KingSoft Spreadsheet supports any kind of automation.
    Have you checked the documentation and/or KingSoft website?

    Otherwise you can directly write a XSLX file.

  6. #6

    Thread Starter
    Registered User
    Join Date
    Mar 2014
    Posts
    6

    Re: VB6 - Export flexgrid to kingsoft spreadsheet 2013

    Can I directly write a XLSX file using vb6 even only kingsoft in my computer?

  7. #7
    PowerPoster Arnoutdv's Avatar
    Join Date
    Oct 2013
    Posts
    6,747

    Re: VB6 - Export flexgrid to kingsoft spreadsheet 2013

    Yes, I posted a sample in the CodeBank, see post #3
    A xlsx file is just a zip file with some xml documents.
    If you rename a .XLSX file to .ZIP then you can view the readable content

  8. #8

    Thread Starter
    Registered User
    Join Date
    Mar 2014
    Posts
    6

    Re: VB6 - Export flexgrid to kingsoft spreadsheet 2013

    Hi, Arnoutdv. I've tried the sample but I don't understand what I supposed to do? Would you like to give me other sample which more simple. Sorry, because I'm newbie in vb6

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width