, password, writerespassword, ignorereadonlyrecommended, origin, delimiter, editable, y, converter, addtomru, local, corruptload)
Filename is a required parameter, indicating the name of the workbook to be opened. If no path is specified, it indicates the current path. The other 14 are optional parameters, except Password parameters, which are rarely used. For specific meanings, see the help of VBA.
Example:
Workbooks. Open "F: test.xls"
Open the test.xls file on the fdisk.
2. Open a text file
Y
method to create a series of changing methods. Each method has a list of different parameters.
Scope:The default scope of the shared method is public. We can also set the sharing method to friend, protected, or private in the Declaration. In fact, when a method is overloaded, we have different scopes as long as the parameter list is different.
Usage:How is the sharing method used? Let's look at an example. When we want to open a text file for the input, we can use a shared code in the
This article is a learning note, C # advanced programming 6 chapter 25 file and registry operations
1. Manage File Systems
1. File directory is a static class. You can use these classes to call only one operation of a File or folder.
FIleInfo DirectoryInfo is a sealed class and needs to be instantiated. Therefore, if you operate a file multiple times, you can use these classes.
2. FileInfo can execute Open (), OpenRead (), OpenText (), OpenWrite (), C
();If (PB. Ad. Street! = "")Break;Else{Outmsg (1 );}}
While (true){Try{Console. writeline ("enter your house number :");PB. Ad. No = convert. touint32 (console. Readline ());Break;}Catch{OutMsg (2 );}}
Info = "your information is as follows: \ r \ n" + "name:" + pb. name + "\ r \ n age:" + pb. age + "\ r \ nTel: "+ pb. phone +" \ r \ n address: "+ pb. ad. city +" city "+ pb. ad. street +"Street" + pb. ad. no + ";Write_info = "name:" + pb. name + "\ r \ n age:" + pb. age + "\ r \ n Tel:" + pb. p
);Oledbdataadapter mydata = new oledbdataadapter (myoledbcommand );Mydata. Fill (RS );Conn. Close ();}}}Else{System. Io. streamreader tmpstream = file. opentext (filepath );String tmpstr = tmpstream. readtoend ();Tmpstream. Close ();Rs = getdatatablefromstring (tmpstr );Tmpstr =;}Return Rs;}/// /// Convert the data of the specified HTML string to a able object. The data is processed based on special characters such as /// /// /// Private Static datat
In wince, relative paths cannot be used. absolute paths must be used to locate files.
For example, the abc.txt file under the Program Files \ testprogramvisual directory can only be used
Program Files \ testprogram \ abc.txtto locate the location, but cannot use abc.txt to locate the location.
For example:
Private void button#click (Object sender, eventargs E){
String Path = "Program Files \ testwince \ configpio.txt ";Using (streamreader sr = file.
Information/// Public foundationservice{Get{Return m_found;}}/// /// Order Management/// Public orderservice{Get{Return m_order;}}Public systemvm (){Loadbusinessobj ();}/// /// Return the template type that can be selected by the system based on the template type./// /// /// Public xmlnodelist getxmljavascriptbytype (string stype){Xmlnodelist = xmljavascript. selectnodes ("// item [@ type = '" + stype + "']");If (xmlnodelist. Count {Throw new exception ("the node of Type [" + stype + "] cannot
file for writing text.· Opentext: open an existing text file for reading.But the above method mainly on the UTF-8 encoding text operations, which is not flexible enough. We recommend that you use the following code to operate the TXT file.· Read the TXT file. The sample code is as follows: Streamreader txtreader = new streamreader (@ "C: \ tempuploads \ newfile.txt", system. Text. encoding. Default );String filecontent;Filecontent = txtreader. readen
(myoledbcommand );Mydata. Fill (RS );Conn. Close ();}}}Else{System. Io. streamreader tmpstream = file. opentext (filepath );String tmpstr = tmpstream. readtoend ();Tmpstream. Close ();Rs = getdatatablefromstring (tmpstr );Tmpstr = "";}Return Rs;}/// /// Convert the data of the specified HTML string to a able object. The data is processed based on special characters such as /// /// /// Private Static datatable getdatatablefromstring (string tmphtml){S
created. Read content from a file Reading content from a file is roughly the same as writing content to the file, but pay attention to the following two things: 1. Use the streamreader class for File Reading 2. When the Readline method is used, an empty string ("") is used to mark the end of the text file to be read. The write code is now used to read the content from the aspnet.txt file created earlier: In ASP. NET, the entire process of file processing is centered around the namespace s
filestream in the specified path.
20
Openread
Open an existing file for reading.
21
Opentext
Open an existing UTF-8 encoding text file for reading.
22
Openwrite
Open an existing file for writing.
23
Readallbytes
Open a file, read the file content into a string, and then close the file.
24
Readalllines
Open a text file, read all the lines of the file into a string array, and th
streamMyfilestream1.write (mywritebytearray, 0, numberofbytestowrite );// Close the streamMyfilestream1.close ();// Close the streamMyfilestream2.close ();}}}The myfilestream1 object is instantiated using the specified path and creation mode. The Creation Mode filemode is an enumeration type and also includes:
Append
You can open an existing file and find the end of the file. filemode. append can only be used with fileacces. Write (write permission ).
Create
Cr
1. method for obtaining the installation path of the program application. startuppath
For example:
String Path =Application. startuppath + "\ wartercode. xml";
It is equivalent to server. mappath () in ASP. NET ();
2. Operate txt
(1) Determine whether the text exists. If it does not exist, create a text and write data to it. If it exists, read the data in it.
String Path = @ "C: \ wartercode.txt ";Fileinfo Fi = new fileinfo (PATH );If (! Fi. exists){// If it does not exist, create a textStreamwr
I wanted to write and write in five minutes .. I found that vs2003 could not use 1.1 to write one on the machine ..
Every time, we use a new Google .. This is no exception .. Grandma's .. We found that it was actually 2.0 of the Code .. Helpless. I found myself .. After 10 minutes, I wrote some code ..
Some source code is as follows (the following code is available for download ):
------------------------------------------------------------
XML code:
--------------------------------------------
A few days ago, I/O processing encountered a problem that could not be operated.The file "D: \ log \ cargoabc \ logfilecargoabc.txt" is being used by another process. Therefore, this process cannot access the file.Logfilecargoabc.txt is a log file and may be written to it by another program from time to time.I/O streams need to be used to read log files and display them in log query.1. filestream FS = file. openread (URL );Streamreader sr = new streamreader (system. Io. Stream) FS, system. Text.
1. It is convenient to write --------- to cells one by one, but the speed is slow.
2. Using the Excel feature, the data in each column is first separated by \ t, each row is separated by \ r \ n, and finally pasted to the clipboard ---------- with a slightly higher speed, however, if a copy and paste task is executed externally, errors may occur.
3. assign values directly to the corresponding area of the array through arrays. ---------- Very convenient for datatable. You can assign a value dir
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.