Export SQL Server Data to Multiple Excel Worksheets with C#

SELECT
    SalesOrderID,
    MAX(UnitPrice) as UnitPrice, max(OrderQty) as Quantity
FROM Sales.SalesOrderDetail
GROUP BY SalesOrderID
HAVING COUNT(SalesOrderID) = 1 and max(OrderQty) > 1
order by SalesOrderID

Select
    employees.BusinessEntityID, employees.Name, employees.JobTitle, employees.Department,
   employees.StartDate, 
    managers.name [Reports to], 
    case when employees.JobTitle != managers.JobTitle then managers.JobTitle else '' end 
        [Manager Job Title]
from 
   (
        SELECT
            e.[BusinessEntityID], 
            p.FirstName + case when p.MiddleName is not null then ' ' + p.MiddleName else '' end +
               ' ' + p.LastName [Name],
            e.[JobTitle], d.[Name] AS [Department], edh.[StartDate], 
            case when e.OrganizationLevel is null then 0 else e.OrganizationLevel end
               OrganizationLevel,
            case when e.OrganizationNode is null then '/' else
               e.OrganizationNode.GetAncestor(1).ToString() end OrganizationNode
        FROM Person.Person p
            join HumanResources.Employee e on e.BusinessEntityID = p.BusinessEntityID
            JOIN [HumanResources].[EmployeeDepartmentHistory] edh 
                ON e.[BusinessEntityID] = edh.[BusinessEntityID] 
            JOIN [HumanResources].[Department] d ON edh.[DepartmentID] = d.[DepartmentID] 
        WHERE edh.EndDate IS NULL
    ) employees
    join
   (
        SELECT
            e.[BusinessEntityID], 
            p.FirstName + case when p.MiddleName is not null then ' ' + p.MiddleName else '' end +
               ' ' + p.LastName [Name],
            e.[JobTitle], d.[Name] AS [Department], edh.[StartDate], 
            case when e.OrganizationLevel is null then 0 else e.OrganizationLevel end
               OrganizationLevel,
            case when e.OrganizationNode is null then '/' else e.OrganizationNode.ToString() end
               OrganizationNode
        FROM Person.Person p
            join HumanResources.Employee e on e.BusinessEntityID = p.BusinessEntityID
            JOIN [HumanResources].[EmployeeDepartmentHistory] edh
                ON e.[BusinessEntityID] = edh.[BusinessEntityID] 
            JOIN [HumanResources].[Department] d ON edh.[DepartmentID] = d.[DepartmentID] 
        WHERE edh.EndDate IS NULL
    ) managers
    on employees.OrganizationNode = managers.OrganizationNode
group by employees.department, employees.JobTitle, employees.OrganizationLevel,
    managers.name, 
    managers.JobTitle, 
    employees.[name], employees.BusinessEntityID, employees.StartDate
order by employees.OrganizationLevel,  employees.JobTitle

xlsWorkbook.Sheets.Add(); // Add a second sheet

// Create the header for the first sheet
xlsSingleItemOrder = (Excel.Worksheet)xlsWorkbook.Sheets[1];
xlsSingleItemOrder.Name = "Single Item Sales";
xlsSingleItemOrder.Cells[1, 1] = "Single Item Sales";
Excel.Range rangeSingleItems = xlsSingleItemOrder.get_Range("A1", "D1");
rangeSingleItems.Merge(1);
rangeSingleItems.Borders.Color = Color.Black.ToArgb();
rangeSingleItems.Interior.Color = Color.Yellow.ToArgb();
rangeSingleItems.Font.Name = "Courier New";
rangeSingleItems.Font.Size = 14;
rangeSingleItems.Cells.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenterAcrossSelection;

// Create the header for the second sheet
xlsManagers = (Excel.Worksheet)xlsWorkbook.Sheets[2];
xlsManagers.Name = "Company Organization Structure";
xlsManagers.Cells[1, 1] = "Company Organization Structure";
Excel.Range rangeManagers = xlsManagers.get_Range("A1", "G1");
rangeManagers.Merge(1);
rangeManagers.Borders.Color = Color.Black.ToArgb();
rangeManagers.Interior.Color = Color.Yellow.ToArgb();
rangeManagers.Font.Name = "Courier New";
rangeManagers.Font.Size = 14;
rangeManagers.Cells.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenterAcrossSelection;