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
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
  1. Home
  2. General Programming
  3. Visual Basic
  4. How to send text strings to Excel Worksheet?

How to send text strings to Excel Worksheet?

Scheduled Pinned Locked Moved Visual Basic
questiontutorial
1 Posts 1 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.
  • R Offline
    R Offline
    Rashar
    wrote on last edited by
    #1

    Hello, I have a small app that reads in a text file line by line. How do I take each line of text and dump it into an Excel Worksheet? Do inputLine = sr.ReadLine If Not (inputLine Is Nothing) Then strColumn1 = inputLine.Substring(38, 28).Trim strColumn2 = inputLine.Substring(66, 12).Trim strColumn3 = inputLine.Substring(78, 1).Trim strColumn4 = inputLine.Substring(79, 4).Trim strColumn5 = inputLine.Substring(90, 7).Trim strColumn6 = inputLine.Substring(99, 2).Trim strColumn7 = inputLine.Substring(102, 2).Trim strColumn8 = inputLine.Substring(108, 3).Trim 'here I would like to take the values of my Columns and create a CSV file or write the values of my columns to a blank Excel worksheet... End If Loop While Not (inputLine Is Nothing) Thanks in advance, Rashar

    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