Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

'XlsxWriter' object has no attribute 'save'. Did you mean: '_save'?

ayi

I’m trying to save data from a DataFrame to an Excel file using pandas. I tried the following code: 
import pandas as pd import xlsxwriter data = {‘Name’: [‘John’, ‘Jane’, ‘Adam’], ‘Age’: [25, 30, 35], ‘Gender’: [‘M’, ‘F’, ‘M’]} df = pd.DataFrame(data) writer = pd.ExcelWriter(‘output.xlsx’, engine=‘xlsxwriter’) df.to_excel(writer, sheet_name=‘Sheet1’) workbook = writer.book worksheet = writer.sheets[‘Sheet1’] <h1><a name="p-34997-example-adding-a-chart-1" class="anchor" href="#p-34997-example-adding-a-chart-1" aria-label="Heading link"></a>Example: Adding a chart</h1> chart = workbook.add_chart({‘type’: ‘line’}) chart.add_series({‘values’: ‘=Sheet1.$B$2:$B$4’}) worksheet.insert_chart(‘D2’, chart) writer.save() <pre><code class="lang-auto"> But I get the following error:writer.save()
^^^^^^^^^^^
AttributeError: 'XlsxWriter' object has no attribute 'save'. Did you mean: '_save'?

</code></pre>
Does anyone know how to solve it?

ayi_2

The <code>save()</code> method has been deprecated and removed in Pandas. You should use <code>close()</code> instead.
With older versions of Pandas you would have gotten this warning:
<blockquote></blockquote>
FutureWarning: save is not part of the public API, usage can give unexpected results and will be removed in a future version
With more recent versions you just need to use <code>close()</code> like this (I also fixed the syntax for the chart values): 
`import pandas as pd 
import xlsxwriter
data = { 
“Name”: [“John”, “Jane”, “Adam”], 
“Age”: [25, 30, 35], 
“Gender”: [“M”, “F”, “M”], 
} 
df = pd.DataFrame(data)
writer = pd.ExcelWriter(“output.xlsx”, engine=“xlsxwriter”) 
df.to_excel(writer, sheet_name=“Sheet1”)
workbook = writer.book 
worksheet = writer.sheets[“Sheet1”]
<h1><a name="p-34998-example-adding-a-chart-1" class="anchor" href="#p-34998-example-adding-a-chart-1" aria-label="Heading link"></a>Example: Adding a chart</h1>
chart = workbook.add_chart({“type”: “line”}) 
chart.add_series({“values”: “=Sheet1!$C$2:$C$4”}) 
worksheet.insert_chart(“E2”, chart)
writer.close()
<pre><code class="lang-auto">
Output:</code></pre>