Skip to main content
3,628 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
4 votes
1 answer
94 views

a = np.array(["foo", "foo", "foo", "foo", "bar", "bar", "bar", "bar", "foo", "foo", &...
Tyler's user avatar
  • 139
0 votes
1 answer
115 views

Is it possible to overwrite and save a DataFrame to an Excel or CSV file if that file is already open? I tried using df.to_excel("file.xlsx", index=False) to overwrite an existing Excel file ...
Ayuba Ahmed Bayugo's user avatar
  • 1
0 votes
1 answer
96 views

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" ...
user1435216's user avatar
  • 3
0 votes
0 answers
68 views

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....
snehlata's user avatar
  • 35
0 votes
0 answers
35 views

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 ...
Venkateshwaran Murugesan's user avatar
  • 31
0 votes
3 answers
122 views

I have this kind of data: [{"id": 1, "name": "Alex", "projects": ["A", "B", "C"]}, {"id": 2, "name": "Bob&...
Aykhan Aghayev's user avatar
  • 1
1 vote
3 answers
188 views

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....
Artyom's user avatar
  • 109
0 votes
1 answer
76 views

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 ...
clme's user avatar
  • 45
0 votes
0 answers
85 views

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 ...
Indranil's user avatar
  • 2,873
0 votes
0 answers
37 views

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 ...
rallyTheCap's user avatar
  • 1
1 vote
2 answers
97 views

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 ...
Mindy's user avatar
  • 11
0 votes
0 answers
25 views

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 ...
Sarina Sohaili yekta's user avatar
  • 1
0 votes
0 answers
47 views

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 ...
Phil Edwards's user avatar
  • 15
0 votes
1 answer
65 views

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(...
AdorableRaspberry953's user avatar
  • 1
0 votes
0 answers
43 views

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 ...
SmartAss's user avatar
  • 1
0 votes
3 answers
68 views

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 ...
Ruth Cundy's user avatar
  • 17
2 votes
0 answers
186 views

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 ...
TheSun's user avatar
  • 21
0 votes
0 answers
64 views

I've been struggling to get a handle on OpenXML and my most recent roadblock has been TotalsRows. I've tried using combinations of the following: Table table = new Table { ...
yewie's user avatar
  • 1
0 votes
1 answer
49 views

I'm getting a network error when trying to download an Excel file from my web application hosted on a remote server. The request returns 200 OK response in network tab and file downloads until 64kb (...
Nic's user avatar
  • 23
0 votes
1 answer
119 views

I'm using the last python version to date (3.13.1). I can compile code with xlwt, and executing my code though the console works. But when I want to execute the file double-click style it fails to ...
Pernoctador's user avatar
  • 100
-1 votes
2 answers
131 views

I have an export to a .xlsx spreadsheet in Excel which is generated when the user supplies a date range and the car name. This works at the moment and displays the data correctly. The file name must ...
Need Help's user avatar
  • 1
0 votes
1 answer
76 views

I have two mysql tables in following format Table 1 - Institute Basic Details (institute_basic_details) id | institute_unique_id | institute_name | institute_city 1 ABCD1234 ...
Dr M L M J's user avatar
  • 2,387
2 votes
1 answer
88 views

I am using PrimeFaces 11 and I have a scenario where I have to export dataTable to Excel in a form. My .xhtml code looks like this: <p:commandButton id="cmdexcel" value="#{text.Excel}...
Mani Ratna's user avatar
  • 921
0 votes
0 answers
77 views

I am trying to export the results of a stored procedure to an Excel spreadsheet. However, although the database has some values of 0 (for temperature and hours of use) which are relevant values, it ...
Need Help's user avatar
  • 1
0 votes
1 answer
60 views

I am trying to export a datatable as Excel Format using this command. webix.toExcel($$("coretableCDC"), { filterHTML: true }); GUI - Excel 39E76 - 3.9E+77 39E78 - 3.9E+79 4E2FE - 4E2FE ...
Jeevan's user avatar
  • 487
0 votes
0 answers
67 views

I use ClosedXML(0.102.3) to modify Crystal Report export Stream, when I use this code ReportDocument crReportDocument = new ReportDocument(); crReportDocument.Load("D:\\Sample\\test.rpt"); ...
darkwindstom's user avatar
  • 1
1 vote
1 answer
741 views

I did some data analysis on Google Xolab, and now I want to export the finished table into Excel. It doesn't let me directly download to my downloads (or other folders). I guess this is because it is ...
Ian Burner's user avatar
  • 11
0 votes
1 answer
78 views

I have a bunch of text strings separated by commas in a cell (e.g., in COLUMN A here). Column A Column B AA,AB,AC ?? AC,AZ,BB ?? AB,BB,CD ?? Each one of these texts is associated with values in a ...
Anonymous's user avatar
  • 5
0 votes
1 answer
109 views

I am modifying existing reports using Visual Studio 2022, I make changes NOT related to the style (colors, fonts etc.) The report is also deployed Visual Studio 2022. Then I am publishing to an SSRS ...
DBTales's user avatar
  • 101
1 vote
0 answers
73 views

I'm working on a Fastify application where I have set up various routes, including one to export data to an Excel file. However, when I try to access the /export-excel route via a POST request, I'm ...
Eliria Mirna Bernardo Tolledo 's user avatar
  • 11
0 votes
1 answer
70 views

I need help with Excel to display data based on drop-down selections. I have a table with "Name" and "Gender." How can I set it up so when I select "Male" or "Female&...
sajan tiwari's user avatar
  • 11
0 votes
0 answers
181 views

I'm trying to use pandas Dataframe Styler possibilies (looks very cool). My need is to output the dataframe in both Excel, pdf and HTML format. Here is the sample code : import pandas as pd from ...
Jerry's user avatar
  • 61
0 votes
1 answer
66 views

I have DHTMLX Spreadsheet v5.x in my Angular project. I need to push the updated Spreadsheet file to the server. The built in method creates and autodownloads the xlsx file. let spreadsheet = new ...
NBo's user avatar
  • 31
0 votes
0 answers
59 views

I am extracting data from a csv attachment in Outlook and when it pastes into my xlsm workbook it retains the csv formatting. I need it to spread across the cells/columns like it does automatically ...
mclawler's user avatar
  • 3
1 vote
1 answer
75 views

I am exporting a report from SSRS to Excel. I have grouped the data into two (2) pages in SSRS based on whether the value of a single column is less than zero (0) or not. I want to name one sheet in ...
JAG's user avatar
  • 21
-1 votes
1 answer
66 views

hope be well. I have multiple quantity take-off and each quantity has a specific worksheet. I faced error when I wanted to create the table for them The error was "Table name invalid" the ...
NIA BIM's user avatar
  • 9
0 votes
0 answers
61 views

I want to change font color of specific cells text, with export using openXML, C#, I am using predefined excel template to fill data and export from my application. Here is my code, Please help me to ...
user24241471's user avatar
  • 13
0 votes
1 answer
174 views

I am trying to convert a PDF report into CSV file. So currently a query is used to generate the report. To convert into csv, i wrote a CL program and added two commands RUNQRY and saved the output in ...
Sonika Agarwal's user avatar
  • 1
1 vote
0 answers
388 views

I was earlier using 28.0.1 of react ag grid. I upgraded to 32.2.0 and now gridApi.exportDataAsExcel() is not working. It's giving error as - unable to export as package ag-grid-enterprise has not been ...
user13569341's user avatar
  • 21
-2 votes
3 answers
965 views

I am using a PDF to Excel converter where I scrape some values from the spreadsheet once converted. However, an error occurs when I try and paste this to another spreadsheet: source files contain ...
user22005575's user avatar
  • 17
0 votes
1 answer
223 views

I have data in below format in ag-grid and when I try to export to excel all the rows got exported except "Total" row. product category price1 price2 price3 apple fruit1 3 4 5 ...
sandy's user avatar
  • 95
0 votes
1 answer
203 views

I'm using Apache POI and trying to add a date format style to a numeric field in my spreadsheet. But when I add a style to my Cell it fails to open in Excel (tries to repair the file). My code looks ...
Bobert's user avatar
  • 672
0 votes
1 answer
100 views

I would like to download data from a website to Excel in order to create my own statistics. I tried power query but couldn't get everything I wanted. For example, here is a specific URL: https://www....
Karesz's user avatar
  • 13
1 vote
1 answer
51 views

I have a Pandas DataFrame that I want to export to Excel. When doing so using pd.to_excel(...) my floats are getting slightly faulty. Something like: df = [0.019,2.117,9.999] excel = [0.018999901104,...
jigga's user avatar
  • 624
0 votes
0 answers
47 views

I'm using CsvHelper.Excel.ExcelWriter class from Nuget Pack (CsvHelper.Excel.Core). It works if I only try to write on FileStream, but it doens't on MemoryStream. It Works using (var w = new ...
bit's user avatar
  • 973
-1 votes
1 answer
247 views

I working on export html table to excel using JAVASCRIPT . I face issue it not export to excel office New version with extension xlsx . but it working fine and export to old version office excel with ...
ahmed salah abd elaziz elbarba's user avatar
  • 37
0 votes
3 answers
94 views

I have a code that takes too long to calculate an Array[Array[Array[Double]]], but I need the result to calculate something else with different parameters but the same Array[Array[Array[Double]]] so ...
Hulmi's user avatar
  • 1
2 votes
2 answers
307 views

I do not want collaborators to make changes in Excel files I export from R. Actually I export them using writexl::write_xlsx() or sometimes WriteXLS::WriteXLS() functions and afterwards I have to open ...
Alfonso Gar's user avatar
  • 61
0 votes
1 answer
59 views

I'm trying to make a excel workbook for a game called torn city. I want users to be able to input their game key into a cell and then excel automatically pulls the data from a link with the combined ...
Kyle Bekker's user avatar
  • 1
0 votes
1 answer
1k views

I haven't found a way to do the following yet: Read a very large data set Write the data to an Excel file (avoid JVM out-of-memory, but ideally don't want to write the whole thing to disk) Upload it ...
Bobert's user avatar
  • 672

1
2 3 4 5
…
73