SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 6 of 6
  1. #1
    Senior Member
    Join Date
    Oct 2001
    Location
    NC, United States
    Posts
    148
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Sample code for data input and output to Excel.

    Hi,
    Does anyone has sample code that I can use for basic data input and output to Excel sheet. I would greatly appriciate it !!
    please email me if possible milap54321@yahoo.com or post the loaction here.
    Thanks in advance !!
    -gram

  2. #2
    Member
    Join Date
    Apr 2005
    Location
    Delhi
    Posts
    81
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Sample code for data input and output to Excel.

    To read data from CSV file..here is the code... and for writing use FileWriteLine function.

    [-] List of String GetFileData(string csvFile)
    [-] do
    [ ] List of string lsFileData
    [ ] HFILE hFile
    [ ] String sLine=""
    [ ] hFile = FileOpen (csvFile, FM_READ)

    [ ] FileReadLine(hFile, sLine)


    [-] while(FileReadLine(hFile, sLine))
    [ ] ListAppend(lsFileData,sLine)
    [ ] FileClose (hFile)
    [ ] print("'{csvFile}' is read")
    [ ] return lsFileData


    [-] except
    [ ] ExceptPrint()
    [ ] LogError("File could not be read")
    [ ] return null
    Thanks
    Yash

  3. #3
    Senior Member
    Join Date
    Oct 2001
    Location
    NC, United States
    Posts
    148
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Sample code for data input and output to Excel.

    Thanks for the code..I have a excel sheet that has several sheets and each sheet (Table) has several columns.
    I want to be able to specify table name and column name. Do you have code for that?
    Thanks
    -gram

  4. #4
    Senior Member
    Join Date
    Nov 1999
    Location
    Eagle, ID,USA
    Posts
    1,035
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Sample code for data input and output to Excel.

    first read the ' READ HERE BEFORE POSTING ' post. This will, among other things, instruct you to search this forum before posting. Chances are, you'll find what you're looking for.
    Have you ever noticed? Anybody going slower than you is an idiot, and anyone going faster than you is a maniac.

  5. #5
    Senior Member
    Join Date
    Oct 2001
    Location
    NC, United States
    Posts
    148
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Sample code for data input and output to Excel.

    Tony, I did the seach on 'sample code excel' didn't comeup with what I needed.
    If you know of any posting do let me know. I'd highly appriciate it...
    -gram

  6. #6
    Senior Member
    Join Date
    Nov 1999
    Location
    Eagle, ID,USA
    Posts
    1,035
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Sample code for data input and output to Excel.

    Have you ever noticed? Anybody going slower than you is an idiot, and anyone going faster than you is a maniac.

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 10.71%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 04:19 PM.

Copyright BetaSoft Inc.