Tag: excel

  • Adding Parameters To Excel SQL Query

    The other day, I was asked to make an Excel spreadsheet that was populated by a SQL stored procedure parameterized. This spreadsheet is supposed to run each month to analyze the previous month’s sales and commissions. I wrote a stored procedure that automatically pulled the previous month’s data. Now, they wanted to specify the Start…

  • Problem POSTING a SharePoint form multiple times

    I created a web part that displays data in an HTML table. On this web part, there is also a button that says, Export to Excel. When the button is clicked, the form posts to the server and my server-side code responds with an Excel file. The problem is that it only works once. To…