3,629 questions
0
votes
1
answer
70
views
Export data from excel workbook to Memorystream
I have a WPF application in which I have to send email with attachment. I have designed a new window to send email in application which will be displayed when user click on "send email" ...
0
votes
0
answers
57
views
Using list which depends on another list in excel using python
I have a requirement to create dependent dropdowns in excel using python.
import os
import openpyxl
from openpyxl.styles import Border, Side, PatternFill, Font, Alignment, numbers
from openpyxl....
- 35
0
votes
0
answers
32
views
Getting an Error "e is not a function" While Exporting the data from the angular-slickgrid
Issue Summary:
I'm using the Excel export feature of angular-slickgrid (version 7.7.0) to export a large dataset from a grid. However, I'm encountering the following error in the browser console:
e is ...
0
votes
3
answers
112
views
How list in pandas dataframe can be converted into multiple cells with no duplicate values?
I have this kind of data:
[{"id": 1, "name": "Alex", "projects": ["A", "B", "C"]}, {"id": 2, "name": "Bob&...
1
vote
3
answers
127
views
Jasper report Excel row height
I need help with Jasper reports.
In XLS when content doesn't fit the row width the row height increases. But at the top and the bottom in some rows content is cut off.
I've tried properties:
net.sf....
- 87
0
votes
1
answer
56
views
Change orientation of table Header using xlsxwriter
I am exporting a quite large table (40 rows including header; 69 columns)
The majority of the columns are just numbers so I set the width to, e.g., 5.
This results in unreadable columns headers. Now I ...
- 45
0
votes
0
answers
64
views
error200280_01.xml - Ag Grid Excel Export - error after downloading the excel
I have implemented export to excel for ag grid with version "ag-grid-react": "^33.0.3". Now, when we download the excel we are getting this error: We found a problem with some ...
- 2,863
0
votes
0
answers
25
views
AgGrid Empty RowGroups heading lost when exporting to excel
I'm using AgGrid React with row groupings. For entries that do not have a value for the Column I'm grouping by, it shows as '(Blanks)' in the table which is fine, but exporting to excel loses that ...
1
vote
2
answers
77
views
SSIS - Export SQL to Excel - Date Format Issues
I am new to SSIS but not SQL. I'm using SSIS to export a query to an Excel spreadsheet. The problem I'm having is the date fields are not in a date format. They appear as a date but the cell format is ...
- 11
0
votes
0
answers
23
views
Python project -"Adjusting based on the days in a month" & "Adding multiple statements in a cell through loops without overwriting"
I am using a bunch of for loops to print milestones and their names on an excel sheet. The visuals do not match the day (i.e 28th of feb should be near the end of the cell) and when I try printing ...
0
votes
0
answers
41
views
Is there a way to make an Excel spreadsheet reflect the data in a SharePoint list, and update when changes are made to the list?
I can find plenty of ways to update a SharePoint List from an Excel spreadsheet, but not the other way around.
I'm looking for a way I can have an Excel Spreadsheet which is automatically updated when ...
- 15
0
votes
1
answer
59
views
How can I skip Excel Files if they do not contain a specific Sheet?
Here's the code I'm using:
library(readxl)
setwd(file.path(dirname("~"), "/Shared Documents/Programs/Data and Reporting/Data Quality Reports/Org Level Data"))
lst = list.files(...
0
votes
0
answers
38
views
Is there a way to set Normal Style for workbook using DevExpress.Export.Xl?
I'm trying to recreate an existing Excel report using the DevExpress Excel Export API.
To achieve this goal, I need to set the column width to exactly match the original. The Xlsx file stores column ...
- 1
0
votes
3
answers
65
views
I need to export one tag from multiple XMLs to give me a list of all the graphics used within the XMLs
I have a few thousand XMLs and I need to produce a list of all the graphics referenced in those XMLs to make sure I have them all before converting to PDF.
Here is an example from the XML where a ...
- 17
1
vote
0
answers
138
views
Issues with Applying AutoFilter in ExcelJS
I'm working with the ExcelJS library to manipulate an Excel file in my React application. I have a template Excel file that already contains some auto filters applied to the rows
After I edit the ...
- 21