University:
Georgia Southern University
Course:
ENGR1121 | Computing in Mechanical Engineering
Academic year:

2024
Views:

312

Pages:

13
Author:

Jalen W.

IMPORTING DATA FROM A TEXT FILE • First, be sure that the file containing the data really is a text file; i.e., it contains no formatting from a word processor, etc. Text files typically have the extension .txt, .csv, or .prn.) • If the text file contains multiple data items within each line, be certain that the data items are separated by blank spaces, commas, semicolons, or tabs (or some combination thereof). Example 9.1 Importing Data from a Text File • data had originally been entered into a text file, with each pair of data items (i.e., time and the accompanying voltage) entered on a separate line and separated by a comma and a blank space Example 9.2 Exporting Data to a Text File Note that the worksheet includes numerical constants, numerical data generated from formulas, and labels (strings). Save the worksheet data in two different text files, using tabs as separators in the first text file and commas in the second. lines containing the Richardson and Williams data extend out to the right because the names extend beyond the first tab space. Adding a tab before the first exam score for each student with a shorter name will correct this problem. Reading work • TRANSFERRING HTML DATA • TRANSFERRING DATA TO MICROSOFT WORD • Copying Directly to Word • Embedding within Word • Linking between Word and Excel • TRANSFERRING DATA TO MICROSOFT POWERPOINT