Is it possible to run a ProfitandLossStandard report and have the total column excluded?

Sure, try:

sp_report ProfitAndLossStandard show Text, Label, Amount_1 as Amount, Amount_1_Title as "As of"
parameters DateMacro = 'ThisMonthToDate', SummarizeColumnsBy = 'TotalOnly'
where RowType <> 'SubtotalRow'

See: How do I run a Profit & Loss Standard Report? for more.

So, if i where to run the following code, I would like the total column to be excluded.  Right now it returns 10 amount columns (the 10th being the total column) but I would like it to return only nine amount columns.

sp_report ProfitAndLossStandard show 'IS' as Report,'AdCafe' as Company, AccountType, Label as Natural_Account, Amount  parameters DateFrom = {d '2008-01-01'}, DateTo = {d '2008-09-30'}, SummarizeColumnsBy= 'Month' where RowType = 'DataRow'

OK, in this example where I have 12 month amount columns and the Total Column:

sp_report ProfitAndLossStandard show Text, Label, Amount_1_Title as Month_1, Amount_1,
Amount_2_Title as Month_2, Amount_2, Amount_3_Title as Month_3, Amount_3,
Amount_4_Title as Month_4, Amount_4, Amount_5_Title as Month_5, Amount_5,
Amount_6_Title as Month_6, Amount_6, Amount_7_Title as Month_7, Amount_7,
Amount_8_Title as Month_8, Amount_8, Amount_9_Title as Month_9, Amount_9,
Amount_10_Title as Month_10, Amount_10, Amount_11_Title as Month_11, Amount_11,
Amount_12_Title as Month_12, Amount_12, Amount_13_Title as Total, Amount_13 as Total_Amount
parameters DateMacro = 'ThisYear', SummarizeColumnsBy = 'Month'

I simply remove Amount_13:

sp_report ProfitAndLossStandard show Text, Label, Amount_1_Title as Month_1, Amount_1,
Amount_2_Title as Month_2, Amount_2, Amount_3_Title as Month_3, Amount_3,
Amount_4_Title as Month_4, Amount_4, Amount_5_Title as Month_5, Amount_5,
Amount_6_Title as Month_6, Amount_6, Amount_7_Title as Month_7, Amount_7,
Amount_8_Title as Month_8, Amount_8, Amount_9_Title as Month_9, Amount_9,
Amount_10_Title as Month_10, Amount_10, Amount_11_Title as Month_11, Amount_11,
Amount_12_Title as Month_12, Amount_12
parameters DateMacro = 'ThisYear', SummarizeColumnsBy = 'Month'

No, it's up to you to work out how many months the inputed DateFrom and DateTo span. But that's why we have these predefined DateMacro options available:

|All|Today|ThisWeek|ThisWeekToDate|ThisMonth|ThisMonthToDate|ThisQuarter|ThisQuarterToDate
|ThisYear|ThisYearToDate|Yesterday|LastWeek|LastWeekToDate|LastMonth|LastMonthToDate|LastQuarter
|LastQuarterToDate|LastYear|LastYearToDate|NextWeek|NextFourWeeks|NextMonth|NextQuarter|NextYear|

so you can pre-determine the number of columns for each of the formats as I have done with DateMacro = 'ThisYear' above.