print(data_frame.head())
workbook = xlsxwriter.Workbook(f'{now}_DP1_scan.xlsx',
{'nan_inf_to_errors': True})
dpscan = workbook.add_worksheet('Dipole Scan Data')
snapshot = workbook.add_worksheet("Snapshot")
data_list = [list(data_frame.columns)] + data_frame.values.tolist()
for x, i in enumerate(data_list):
for y, _ in enumerate(i):
dpscan.write(x, y, data_list[x][y])
dpscan.freeze_panes(1, 0)
var, data = M.Snapshot(Client,
Tunnel='west',
filename='junk',
save=False,
feedback=True)
snapshot_df = pd.DataFrame(var, data[0])
snapshot_df.reset_index(inplace=True)
snapshot_df.columns = ['Values', 'Tag', 'Modbus Address']
snapshot_data_list = [list(snapshot_df.columns)] + snapshot_df.values.tolist()
for x, i in enumerate(snapshot_data_list):
for y, _ in enumerate(i):
snapshot.write(x, y, snapshot_data_list[x][y])
snapshot.freeze_panes(1, 0)
workbook.close()
plt.show()
import Master as M
from datetime import datetime
import sys
config_file_path = str(sys.argv[-1])
Tunnel, PLC_IP = M.config_reader(config_file_path, "Snapshot")
Client = M.Make_Client(PLC_IP)
now = datetime.today().strftime('%y%m%d_%H%M%S') #Taking the current time in YYMMDD_HHmm format to save the plot and the txt file
M.Snapshot(Client, Tunnel, filename = f'.\Output Data\{Tunnel}\Snapshots\{now}_snapshot.txt')
