Member Avatar for danielagaba

hi

i'm trying to design a web application that a sales department can use to generate statistical information from data in an excel document. my problem is they want the option of generating statistical information in particular groupings (week and month) in an excel document. will appreciate any help on how i can accomplish this.

thanks

  • 2 Contributors
  • 1 Reply
  • 63 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by sergb
Member Avatar for sergb

Remember that Excel can open CSV files just fine. CSV files can be easily produced from PHP scripts. You can always produce a CSV file but let the user download it as an XLS file (if that is a requirement).
If you want users to be able to group the data directly in the Excel, consider Excel Pivot Tables.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.