Import/Export MS Excel files

2016-06-17 10:22:47
azalea
3951
Last edited by Renee on 2018-10-23 14:08:02

ZenTao Pro can import/export files in .xls format via the phpexcel class library. Compared with the CSV format, the XLS file provides a better control of format and style.


Now batch import/export stories, tasks, bugs, and cases are supported in ZenTao Pro.


1. Select Excel format

Click Import/Export on the page of stories/tasks/bugs/cases you want to import/export.

 


2. Export Excel files


Click Export->Export Data and choose format.



Files exported has been optimized.


3. Example: Import files

1) Take importing cases as an example.

2) There are two sources of data that can be imported,

   - If you want to change data in the exported Excel file, modify cases in the existing file, or add new data to the existing file as shown below.

 

   --Add data to the template.



3) Steps to import

   -- Click “import Excel”.

 

  -- Select the excel file you want to import.

 

 -- Confirm the Imported data


  -- Click "Save" to complete importing the cases.

This feature can be purchased separately as extension and installed in the open source version.
Contact us to buy this extension at renee@cnezsoft.com
    Write a Comment
    Comment will be posted once reviewed.