23 lines
856 B
Python
23 lines
856 B
Python
import pandas as pd
|
|
import os
|
|
from datetime import datetime
|
|
import webbrowser
|
|
import logging
|
|
|
|
def export_to_excel(products):
|
|
logger = logging.getLogger("FletLogger")
|
|
logger.debug("Entering export_to_excel()")
|
|
if not products:
|
|
logger.debug("No products to export.")
|
|
return
|
|
batches = [products[i:i+50] for i in range(0, len(products), 50)]
|
|
export_folder = "exported_products"
|
|
os.makedirs(export_folder, exist_ok=True)
|
|
for idx, batch in enumerate(batches):
|
|
df = pd.DataFrame(batch)
|
|
filename = os.path.join(export_folder, f"products_batch_{idx+1}_{datetime.now().strftime('%Y%m%d_%H%M%S')}.xlsx")
|
|
df.to_excel(filename, index=False)
|
|
logger.debug(f"Exported batch {idx+1} to {filename}")
|
|
webbrowser.open(os.path.abspath(export_folder))
|
|
logger.debug("Exiting export_to_excel()")
|