cancel
Showing results for 
Search instead for 
Did you mean: 

Connection with XLSX and CSV

SOLVED
Highlighted
New Contributor

Connection with XLSX and CSV

Microsoft Office is not installed on my computer. My question is if I only install the component Microsoft Access Database Engine 2010, is it enough for TestComplete to read csv and xlsx files or do I need a valid license of Microsoft Office? Thanks in advance for your support.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Leader

Re: Connection with XLSX and CSV

Xlsx :
To read yes, to modify you need licence.
Csv :
is simple text, no need of anything to use it.

Un sourire et ça repart

View solution in original post

Highlighted
Contributor

Re: Connection with XLSX and CSV

By installing Microsoft Database Engine 2010 , you can only read data from xlsx files as a DDT object.

Same is the case for reading data from CSV files.

But if you want to create an excel object and try to read or modify the data , no you cannot do this without valid license of Microsoft Office.

View solution in original post

5 REPLIES 5
Highlighted
Community Leader

Re: Connection with XLSX and CSV

Xlsx :
To read yes, to modify you need licence.
Csv :
is simple text, no need of anything to use it.

Un sourire et ça repart

View solution in original post

Highlighted
Contributor

Re: Connection with XLSX and CSV

By installing Microsoft Database Engine 2010 , you can only read data from xlsx files as a DDT object.

Same is the case for reading data from CSV files.

But if you want to create an excel object and try to read or modify the data , no you cannot do this without valid license of Microsoft Office.

View solution in original post

Highlighted
Community Manager

Re: Connection with XLSX and CSV

Thank you for helping, Community!

 

Hi @OscarGJ, please mark the piece of advice that helped you the most as a soultion! Thank you. 


Sonya Mihaljova
Community and Education Specialist

 Join the virtual SmartBear Connect user conference on April 27-28! Get your free virtual ticket today!
Highlighted
Occasional Visitor

Re: Connection with XLSX and CSV

  1. 1. Upload csv-file.
  2. 2. Select «to xlsx» Select xlsx or any other format, which you want to convert (more 200 supported formats)
  3. 3. Download your xlsx file. Wait till your file will be converted and click download xlsx -file.

 

 

myschoolbucks login

Highlighted
New Contributor

Re: Connection with XLSX and CSV

@rajulapati Thanks for your help. I had to install the driver to read CSV files.