Finally found a KZread guy from Bangalore -Whitefield🤩

Thanks a lot ...finally able to use it after struggling for a day

@CodersArcade

Жыл бұрын

Happy to help. Please like share and subscribe. 😊❤️👍

Very clear! Thanks a lot! New user friendly!

@CodersArcade

6 ай бұрын

Welcome. Happy to help 😊

Very useful..

Danke schön sir❤️

Darun dada 👌

@CodersArcade

2 ай бұрын

Jay Jagannath

@CodersArcade

2 ай бұрын

Jay Jagannath

Thank you..

Very helpful. Thank you very much.

@CodersArcade

3 ай бұрын

Welcome 🤗

Very usefull!! Thanks

@CodersArcade

11 ай бұрын

Welcome 😊

thanks! , is there difference b/w import openpyxl and from openpyxl import workbook

@CodersArcade

5 ай бұрын

Good question. All your doubts will be cleared once you go through this video where everything about importing modules into your program has been beautifully explained. Please have a look : kzread.info/dash/bejne/o3md0qqnqK7VadI.htmlsi=lOM1qNNTIvE2BoTi

Code that read xl file and save the plotted charts to device ?any one please

@CodersArcade

4 ай бұрын

Robot Framework is primarily designed for acceptance testing and robotic process automation, and it may not be the best tool for creating charts and saving them. However, you can achieve this by combining Robot Framework with external libraries for reading Excel files and creating charts. One way to do this is by using Python as a scripting language along with the `openpyxl` library for Excel operations and `matplotlib` for plotting charts. Below is an example of how you can achieve this: 1. First, make sure you have Python, Robot Framework, `openpyxl`, and `matplotlib` installed. You can install them using: ```bash pip install robotframework openpyxl matplotlib ``` 2. Create a Robot Framework test script (e.g., `chart_test.robot`) with the following content: ```robot *** Settings *** Library Process Library String Library OperatingSystem *** Test Cases *** Generate and Save Chart ${excel_file} Create Excel File example.xlsx Create Data For Chart ${excel_file} Create Chart ${excel_file} Save Chart ${excel_file} output_chart.png *** Keywords *** Create Excel File [Arguments] ${file_name} Open Excel ${file_name} Set Sheet Value Sheet1 A1 X Set Sheet Value Sheet1 B1 Y Set Sheet Value Sheet1 A2 1 Set Sheet Value Sheet1 B2 2 Set Sheet Value Sheet1 A3 2 Set Sheet Value Sheet1 B3 4 Set Sheet Value Sheet1 A4 3 Set Sheet Value Sheet1 B4 6 Save Excel ${file_name} Create Data For Chart [Arguments] ${file_name} Open Excel ${file_name} ${data} Read Excel Range Sheet1 A1:B4 Log ${data} Save Excel ${file_name} Create Chart [Arguments] ${file_name} Open Excel ${file_name} Create Chart Sheet1 Line X-axis Y-axis Save Excel ${file_name} Save Chart [Arguments] ${file_name} ${output_file} Run Keyword And Ignore Error Create Folder output Run Keyword And Ignore Error Remove File output/${output_file} Run Process python -c "import matplotlib.pyplot as plt; plt.plot([1,2,3,4], [2,4,6,8]); plt.savefig('output/${output_file}')" ``` This example assumes that you want to create a simple line chart based on the data in the Excel file. Adjust the `Create Data For Chart` and `Create Chart` keywords based on your actual data and chart requirements. 3. Run the Robot Framework test: ```bash robot chart_test.robot ``` This script will create an Excel file, populate it with data, generate a chart, and save the chart as `output_chart.png` in the `output` folder. Adjust the file names and chart settings according to your specific requirements.

How to get data/value from a excel table... Pls do a video on that.....

@CodersArcade

2 жыл бұрын

Will surely try to upload a video on the same. Thanks for the suggestion 😊

@CodersArcade

2 жыл бұрын

just a small update we made this video already and now you can see that video by clicking on this link : kzread.info/dash/bejne/iomNqdqyZLi5Z7Q.html

Hi Wen i do in teritory pip install openpyxl it shows command wrong ❌

@CodersArcade

Жыл бұрын

There's nothing wrong with the command here. Please restart your system and the IDE or try to restart your command prompt and terminal and check the installation again. It should work fine.

My spreadsheet contains formula??I want to retain those formula

@CodersArcade

Жыл бұрын

Can you please elaborate what you want to do. Are you reading data ? Or want to write data ?