Xlsxwriter

XlsxWriter 3.2.9 is a Python module used to create Excel XLSX files programmatically. It allows developers and administrators to generate spreadsheets containing text, numbers, formulas, charts, formatting, images, and multiple worksheets without requiring Microsoft Excel to be installed.

The solution supports common spreadsheet automation workflows including report generation, data export, invoice creation, formatted workbook creation, and integration with Python-based applications. It is ideal for developers, data engineers, automation teams, and organizations that need reliable Excel file generation within a customer-controlled Azure environment.

Features of XlsxWriter 3.2.9:

• Create Excel 2007+ XLSX files using Python.
• Write text, numbers, formulas, dates, and hyperlinks to worksheets.
• Supports cell formatting, merged cells, charts, images, and data validation.
• Create multiple worksheets within a single workbook.
• Useful for reports, dashboards, exports, invoices, and automation tasks.
• Does not require Microsoft Excel to be installed on the server.

Usage instructions for XlsxWriter
$ sudo su
$ cd /opt/xlsxwriter
$ source xlsxwriter-env/bin/activate
$ python -c "import xlsxwriter; print(xlsxwriter.__version__)"

Create a test XLSX file:

cat > /opt/xlsxwriter/test_xlsxwriter.py << 'EOF'
import xlsxwriter

workbook = xlsxwriter.Workbook('/opt/xlsxwriter/test_report.xlsx')
worksheet = workbook.add_worksheet('Report')

worksheet.write('A1', 'Product')
worksheet.write('B1', 'Price')
worksheet.write('A2', 'Server')
worksheet.write('B2', 1200)
worksheet.write('A3', 'Storage')
worksheet.write('B3', 800)
worksheet.write_formula('B5', '=SUM(B2:B3)')

workbook.close()

print("XlsxWriter test completed successfully.")
print("File created: /opt/xlsxwriter/test_report.xlsx")
EOF

python /opt/xlsxwriter/test_xlsxwriter.py

Verify the generated file:

ls -lh /opt/xlsxwriter/test_report.xlsx
unzip -l /opt/xlsxwriter/test_report.xlsx | head

Credentials: Not applicable. XlsxWriter is a Python library and does not require a username or password.

Access the application:
Not applicable. XlsxWriter is a command-line Python library and does not provide a web dashboard.

Default access:
SSH to the Azure VM using port 22.

Disclaimer: XlsxWriter is provided “as is” under applicable open-source licenses. Users are responsible for validating generated spreadsheet output, securing their Azure environment, and ensuring that workbook data is handled according to their organization’s compliance and security requirements. This solution is best suited for Python-based Excel file generation, reporting, and automation workloads in development and production environments.