Guest User

Untitled

a guest
Nov 12th, 2018
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. Hi my script add below . Please help me
  2.  
  3. workbook = xlsxwriter.Workbook('demo.xlsx')
  4. worksheet = workbook.add_worksheet('NMOC')
  5. bold = workbook.add_format({'bold': True})
  6.  
  7. # Write some data headers.
  8. worksheet.write('A1', 'RNC', bold)
  9. worksheet.write('B1', 'CELL', bold)
  10.  
  11. f = open("/root/Desktop/Scripting/Update_Table/eaw/testtt.sh",'r').read()
  12.  
  13. # Start from the first cell. Rows and columns are zero indexed.
  14. row = 1
  15. col = 0
  16.  
  17. for rnc, cell in (f):
  18. worksheet.write(row,col, rnc)
  19. worksheet.write(row,col + 1, cell)
  20. row += 1
  21. workbook.close()
  22.  
  23. workbook = xlsxwriter.Workbook('demo.xlsx')
  24. worksheet = workbook.add_worksheet('NMOC')
  25. bold = workbook.add_format({'bold': True})
  26.  
  27. # Write some data headers.
  28. worksheet.write('A1', 'RNC', bold)
  29. worksheet.write('B1', 'CELL', bold)
  30.  
  31. f = open("/root/Desktop/Scripting/Update_Table/eaw/testtt.sh",'r').read()
  32.  
  33. # Start from the first cell. Rows and columns are zero indexed.
  34. row = 1
  35. col = 0
  36.  
  37. for rnc, cell in (f):
  38. worksheet.write(row,col, rnc)
  39. worksheet.write(row,col + 1, cell)
  40. row += 1
  41. workbook.close()
Add Comment
Please, Sign In to add comment