Displaying posts categorized under

Excel

Automatically filling fixed number of rows with given information

Problem: Biologist often need get observations of plant parts, such as the weight of leaf blade, leaf sheath, and imternode, from individual plant. If you are dealing with a large number of plants, the workload will pike up dramatically. Suppose that you use Excel to record your data, you have to keep track your plant [...]

  • Share/Bookmark

An example of processing XML file – treat it as text

The following example describes a way to process XML file, treating the XML file as text file. We all know that XML file is well structured and can be read and written by using specilized functions and classes. Sometime it is more convenient to treat the file as text file. Here is an simple example. [...]

  • Share/Bookmark

Use PERL to processing CSV file as plain text file

There are several modules used to process CSV file in PERL. Please refer to this tutorial to learn more about it. It describes several ways to parse CSV file, such as using Text::CSV module, Tie::CSV_File, Tie::Handle::CSV, and DBD::CSV modules. Here what I describe a very simple way to process CSV without using any modules. Since CSV [...]

  • Share/Bookmark