Understanding File Operations: Writing, Formatting, and Closing
Learn how to create, write to, format, and close files using applications like Notepad, Excel, and more. Explore the process of adding headers, lines, and commas, along with hidden characters affecting file display. Gain insights into converting numbers to strings and creating new rows in Excel.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
Creates the file on disk and opens it for writing Creates the file and opens for writing
Adds the header to the file Header appears in the first line In Notepad and Excel
Comma appears in Notepad Comma separates values in rows in Excel
/n is hidden and moves Notepad to a new line \n starts a new row in Excel
Adds a line to the file Appears as a line in Notepad Appears as a row in Excel
Format() converts a number to a string (i.e. text) First number in the line in Notepad First cell in row 2 in Excel
Comma appears in Notepad Comma separates values in rows in Excel
Format() converts a number to a string (i.e. text) Second number in the line in Notepad Second cell in row 2 in Excel
/n is hidden and moves Notepad to a new line \n starts a new row in Excel
Closes the file so we can open it in Notepad, Excel, ArcMap, etc.