5 Replies - 329 Views - Last Post: 19 February 2020 - 09:22 AM Rate Topic: -----

#1 SacPy   User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 26
  • Joined: 18-June 19

FileNotFoundError: [Errno 2] No such file or directory

Posted 19 February 2020 - 07:49 AM

Hi,
I am using below code to prepare a chart in Excel file.
However I am getting error while running the code.
I have checked the path and it is correct.

Can anyone please help me in this.


# import xlsxwriter module  
import xlsxwriter 
  
# Workbook() takes one, non-optional, argument    
# which is the filename that we want to create.  
workbook = xlsxwriter.Workbook('\\MyRealPathGoesHere\Python Chart Data.xlsx') 
  
# The workbook object is then used to add new    
# worksheet via the add_worksheet() method. 
worksheet = workbook.add_worksheet() 
  
# Create a new Format object to formats cells  
# in worksheets using add_format() method .  
    
# here we create italic format object  
bold = workbook.add_format({'italic': 1}) 
  
# Add the worksheet data that the charts will refer to. 
Data1 = ['Subject', 'Mid Term Score', 'End Term Score'] 
Data2 = [["Math", "Physics", "Biology", "Hindi", "English", "Singing"], 
         [95, 78, 80, 80, 60, 65], 
         [90, 67, 78, 70, 63, 60]] 
  
# Write a row of data starting from 'A1'  
# with bold format . 
worksheet.write_row('A1', Data1, bold) 
  
# Write a column of data starting from   
# 'A2', 'B2', 'C2' respectively .  
worksheet.write_column('A2', Data2[0]) 
worksheet.write_column('B2', Data2[1]) 
worksheet.write_column('C2', Data2[2]) 
  
# set the wdith of B and C column 
worksheet.set_column('B:C', 15) 
  
# Create a chart object that can be added  
# to a worksheet using add_chart() method.  
  
# here we create a column chart object .  
chart1 = workbook.add_chart({'type': 'column'}) 
  
# Add a data series to a chart  
# using add_series method.  
    
# Configure the first series.  
# = Sheet1 !$A$1 is equivalent to ['Sheet1', 0, 0]. 
  
# note : spaces is not inserted in b/w 
# = and Sheet1, Sheet1 and ! 
# if space is inserted it throws warning. 
chart1.add_series({ 
    'name':       '= Sheet1 !$B$1', 
    'categories': '= Sheet1 !$A$2:$A$7', 
    'values':     '= Sheet1 !$B$2:$B$7', }) 
  
# Configure a second series.  
# Note use of alternative syntax to define ranges.  
# [sheetname, first_row, first_col, last_row, last_col].  
chart1.add_series({ 
    'name':       ['Sheet1', 0, 2], 
    'categories': ['Sheet1', 1, 0, 6, 0], 
    'values':     ['Sheet1', 1, 2, 6, 2], }) 
  
# Add a chart title   
chart1.set_title({'name': 'Exam Score distribution'}) 
  
# Add x-axis label  
chart1.set_x_axis({'name': 'Subjects'}) 
  
# Add y-axis label  
chart1.set_y_axis({'name': 'Marks'}) 
  
# set the style of the chart. 
chart1.set_style(14) 
  
# set the plot area layout of chart 
chart1.set_plotarea({ 
    'layout': { 
        'x':      0.15, 
        'y':      0.09, 
        'width':  0.63, 
        'height': 0.40, } }) 
  
# Set a data table on the X-Axis 
# with the legend keys shown. 
chart1.set_table() 
  
# add chart to the worksheet with given 
# offset values at the top-left corner of 
# a chart is anchored to cell D2 . 
worksheet.insert_chart('D2', chart1,  
    {'x_offset': 20, 'y_offset': 5}) 
  
# Finally, close the Excel file   
# via the close() method.   
workbook.close()



Is This A Good Question/Topic? 0
  • +

Replies To: FileNotFoundError: [Errno 2] No such file or directory

#2 andrewsw   User is offline

  • never lube your breaks
  • member icon

Reputation: 6834
  • View blog
  • Posts: 28,360
  • Joined: 12-December 12

Re: FileNotFoundError: [Errno 2] No such file or directory

Posted 19 February 2020 - 08:11 AM

What line causes the error? Post the full error details.

Are you "certain" that the path is correct?
Was This Post Helpful? 1
  • +
  • -

#3 modi123_1   User is online

  • Suitor #2
  • member icon



Reputation: 15564
  • View blog
  • Posts: 62,309
  • Joined: 12-June 08

Re: FileNotFoundError: [Errno 2] No such file or directory

Posted 19 February 2020 - 08:13 AM

Your path is wrong in some fashion. Not enough information to tell.
Was This Post Helpful? 1
  • +
  • -

#4 SacPy   User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 26
  • Joined: 18-June 19

Re: FileNotFoundError: [Errno 2] No such file or directory

Posted 19 February 2020 - 08:40 AM

Hi andrewss I am getting error at below line. Error is code line number 6.

workbook = xlsxwriter.Workbook('\\DummyPath\DummyPath\DummyPath\DummyPath 00-00-2020\Python Chart Data.xlsx')

Getting error as below.
FileNotFoundError: [Errno 2] No such file or directory: '\\DummyPath\DummyPath\DummyPath\DummyPath 00-00-2020\Python Chart Data.xlsx'
Was This Post Helpful? 0
  • +
  • -

#5 modi123_1   User is online

  • Suitor #2
  • member icon



Reputation: 15564
  • View blog
  • Posts: 62,309
  • Joined: 12-June 08

Re: FileNotFoundError: [Errno 2] No such file or directory

Posted 19 February 2020 - 08:52 AM

If you search "python file path" you will find examples of how python handles paths.

Hint - slashes are wrong.
Was This Post Helpful? 1
  • +
  • -

#6 SacPy   User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 26
  • Joined: 18-June 19

Re: FileNotFoundError: [Errno 2] No such file or directory

Posted 19 February 2020 - 09:22 AM

Hi modi123_1 sir, thanks for the help. I will check and revert. Good night.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1