No announcements
Found 2897212 threads
-
3 Votes
URGENT !!! Add DataValidation List Type to Excel column using OpenXML
- Also, create List in one column, so that client can only select possible values for that column. I am not able to achieve this with ...Proposed | 3 Replies | 1582 Views | Created by MittalPatel - Tuesday, May 14, 2013 12:54 PM | Last reply by Chris Sijtsma - Tuesday, May 14, 2013 1:33 PM -
0 Votes
URGENT !!! Add DataValidation List Type to Excel column using OpenXML
with OpenXml. Below is my code to generate Excel file from DataSet. public void ExportDataSet(DataSet ds, string ...Answered | 1 Replies | 6370 Views | Created by MittalPatel - Tuesday, May 14, 2013 1:28 PM | Last reply by Yuri Macrovsky - Friday, May 17, 2013 9:20 AM -
0 Votes
Add DataValidation List in the Excel using JavaScript ActiveXObject : Excel.Application
How to Add Data validation while generating a Excel File using Javascript. I have some static Text like "High,Moderate,Low" which should come down as a ...Unanswered | 4 Replies | 6017 Views | Created by Vidyaraj - Wednesday, January 18, 2012 9:46 AM | Last reply by nidengaurdon - Tuesday, February 7, 2012 10:37 AM -
0 Votes
Delete a column using OpenXML for EXCEL
thank you for you help.I solved the problem by myself. I want to know how to shift columns.because I delete one column,the rest must shift to ...Answered | 2 Replies | 1027 Views | Created by Johnwet - Thursday, January 15, 2015 8:15 AM | Last reply by Johnwet - Tuesday, January 20, 2015 1:55 AM -
0 Votes
Add comma to text using dataValidation to excel
Hi, I am adding list using data validation to excel like this.. using (ExcelPackage excelPackage = new ...Unanswered | 2 Replies | 814 Views | Created by Narsa - Monday, December 9, 2013 6:41 AM | Last reply by Luna Zhang - MSFT - Tuesday, December 10, 2013 5:55 AM -
0 Votes
DataValidation List Type - Include Blank values in the list
Hello, I am creating List in Excel Column with two values. Below is the code for that. I need to include Blank value also in ...Answered | 1 Replies | 2510 Views | Created by MittalPatel - Monday, May 27, 2013 5:49 AM | Last reply by Yuri Macrovsky - Wednesday, May 29, 2013 12:42 PM -
0 Votes
Get excel column values using openxml
I am using openxml in my code.Using that,I need to get the values corresponding to columns specified in a List<string> variable say ...Answered | 3 Replies | 9639 Views | Created by ams16 - Monday, May 14, 2012 11:55 AM | Last reply by 许阳(无锡) - Thursday, May 17, 2012 7:40 AM -
0 Votes
Hide Column in Excel using OpenXML
OpenXML SDK hidden Excel columns. But I'm confused that you have mentioned relational sheet. May I ask one question: Does the associated column should be ...Answered | 4 Replies | 12501 Views | Created by zeeshan.fawad - Thursday, October 24, 2013 2:18 PM | Last reply by XiaoNiZi - Friday, March 8, 2019 3:21 AM -
0 Votes
Excel DataValidation, strange error
;1 appears to work but is effectively producing circular reference not reported by Excel. Row(), Column() is the current cell. You need ...Answered | 2 Replies | 828 Views | Created by semmasu - Monday, December 10, 2012 4:12 PM | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - Monday, December 10, 2012 4:47 PM -
0 Votes
Can't add list column to content type
content types > add from existing site or list columns. I get thisAnswered | 2 Replies | 5109 Views | Created by NLewandrowski - Thursday, April 4, 2013 8:57 PM | Last reply by Prasham - Friday, April 5, 2013 5:57 AM -
0 Votes
DataValidation node List using HTML with Office 2010 problem
get it work. Regarding you want to open your workbook in Office 2003 and 2000, why don't generate the workbook by using OpenXML, which you have already ...Answered | 5 Replies | 3174 Views | Created by BEJAOUI Mourad - Tuesday, September 13, 2011 12:36 PM | Last reply by BEJAOUI Mourad - Thursday, September 22, 2011 1:34 PM -
1 Votes
Export SharePoint list view to Excel using OpenXML
export to excel. If any one has something to export from SharePoint List view to Excel using OpenXML, can you please ...Answered | 2 Replies | 1933 Views | Created by Santhosh S V - Saturday, January 17, 2015 11:33 AM | Last reply by Sudip Misra - Saturday, January 17, 2015 3:40 PM -
0 Votes
add column from list to excel sheet
. Therefore, you need to add the new column to this view apart from adding it to the list. Afterward, refresh your excel ...Unanswered | 5 Replies | 6861 Views | Created by wael_e - Wednesday, November 21, 2012 11:50 AM | Last reply by Hemendra Agrawal - Monday, December 24, 2012 6:32 AM -
2 Votes
reading Excel using openXML
how can i read the excel file using OpenXML SDK. I am new to OpenXML SDK, can some one point the location, from where i can find the ...Answered | 2 Replies | 7414 Views | Created by Sruthi M - Wednesday, July 7, 2010 7:52 AM | Last reply by XL-Dennis - Thursday, July 8, 2010 12:36 PM -
0 Votes
Add Styles to excel spread sheet using openxml
HI i have created an excel sheet using openxml as shown below. I have a requirement to add the background color to the ...Answered | 1 Replies | 17271 Views | Created by Kiran Kumar Gunda - Sunday, February 13, 2011 7:20 PM | Last reply by Bruce Song - Tuesday, February 15, 2011 8:23 AM -
0 Votes
Read excel 2003 using openxml
Hello, Not that here is the right forum to ask that question, but anyway. No, you can't use OpenXML SDK to read any kind of Excel 2003 Data. ...Answered | 1 Replies | 8327 Views | Created by frdotnet - Tuesday, March 22, 2011 12:37 AM | Last reply by Anton Staykov - Tuesday, March 22, 2011 9:59 PM -
0 Votes
Read excel 2003 using openxml
Read excel 2003 using openxml Is it possible to read the xml data or xml format of excel 2003 in open xml. Is there anyway we can read ...Answered | 1 Replies | 6041 Views | Created by frdotnet - Tuesday, March 22, 2011 12:47 AM | Last reply by Bruce Song - Tuesday, March 22, 2011 2:31 AM -
0 Votes
Read Excel Charts using OpenXML
an image (gif, jpg...) using OpenXML. So I suggest that you could use Excel Interop to export chart to image, refer to below ...Answered | 1 Replies | 945 Views | Created by Ranjith Murthy - Tuesday, May 24, 2016 7:51 AM | Last reply by David_JunFeng - Wednesday, May 25, 2016 5:40 AM -
0 Votes
OpenXML,Excel
Hi, Please explain, how to fetch different data table to different sheets of excel sheet using openXML in ...Unanswered | 1 Replies | 2391 Views | Created by Elangovan Panneerselvam - Thursday, December 8, 2011 12:59 PM | Last reply by Lingaraj Mishra - Friday, December 9, 2011 7:27 AM -
1 Votes
c# Filter Excel using OpenXML
only today's values in it, so I have to work with what I get. Currently I am reading the entire sheet in to a DataTable, which not only takes a long time, but is ...Proposed | 1 Replies | 2817 Views | Created by HiArt - Friday, July 7, 2017 3:19 PM | Last reply by Chenchen Li - Tuesday, July 18, 2017 5:35 AM - Items 1 to 20 of 2897212 Next ›
No announcements