There will be 2 methods:
- a single app which will load your excel file, read the worksheet contents and then create the orders in quickbooks. This will process all rows
- an excel addon which will create a new excel ribbon button, and it will retrieve the selected rows, and then create the orders on quickbooks. This method is better as user can interact with excel worksheet internally, no need to switch window of app. Can be used for single or multiple rows
Both method will use Intuit Quickbooks SDK or API. One question: is it for Quickbooks Online or Quickbooks Desktop Edition?
Let me know as I have something ready for Quickbooks Online which works for Items, Customers, Invoices, and Exenses Objects in Quickbooks.